database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
ㆍDB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
DB2 Tutorials 434 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 434
DB2 Limits
작성자
정재익(advance)
작성일
2002-10-17 20:32
조회수
9,016

DB2 Limits (Version 5기준)

 

   Item                                        Limit
 
Columns in table or view               750 or fewer 
                                                  (depends on complexity of CREATE VIEW stmt)
Columns in a dependent table       749
Table names in a view                 15
Row length (including overhead)    
4K pages:                                    4056 bytes   
4K pages with EDITPROC:             4046 bytes 
32K pages:                                   32714 bytes
32K pages with EDITPROC:           32704 bytes
 
Volume IDs in a storage group                         133
Partitions in a partitioned table space                64
Partitions in a large partitioned table space        254

Size of partitions (not large) 
1 - 16 partitions                           4 gigabytes 
17 - 32 partitions                          2 gigabytes 
33 - 64 partitions                          1 gigabytes 
 
Size of partitions (large) 
1 - 254 partitions                          4 gigabytes 
 
Table or table space size            64 gigabytes 
                                                or 1016 gigabytes (~1 terabyte) 
                                                    if large
 
Size of a DBRM                         131072 bytes

Index key length for non-partitioned      254 minus the # 
     table space                                   of key columns 
                                                        that allow nulls
 
Maximum number of bytes used in the     40 minus the # of 
partitioning of a partitioned index               key columns 
                                                             that allow nulls
 
Columns in an index key                       64
Tables and views in a subselect            15 or less depends on 
                                                           complexity of subselect

Host and indicator variable length            32767 bytes 
pointed to in a SQLDA
 
Host variable length used for INSERT or UPDATE   32704 bytes 
 
SQL statement length                            32765 bytes
 
Elements in a SELECT list                    750

Predicates in a WHERE or                     750
HAVING  clause
 
Total columns in a GROUP BY or           750
ORDER BY clause


 Item                                              Limit
 
Total column length in a GROUP BY or ORDER BY clause       4000 bytes 

Maximum length of a table check  constraint                         3800 bytes 

Maximum number of parameters of a                 As many as can be
stored procedure and any CALL                         defined by the
statement referencing the procedure.                 parameter list
The maximum length of the column.                  stored in SYS-PROCEDURES 
                                                                      PARMLIST;
                                                                      3000 bytes
 
Concurrent DB2 or application agents                 Limited by EDM and buffer pool
                                                                     size, and amount of storage used by
                                                                     each DB2 or applic. agent
 
Largest table or table space                             1016 gigabytes
 
Active log space size                                      248 bytes
 
Archive log space size                                   248 bytes
 
Active log copies                                           2
 
Archive log copies                                         2
 
Active log data sets (each copy)                     31
 
Archive log volumes (each copy)                    1000
 
Databases accessible to an application           System storage/EDM pool size
    or end user
 
EDM pool size                                             Install parameter dependent The
                                                                  installation parameter maximum 
                                                                  depends on avaiable space
 
Total databases                                          65279
 
Number of rows per page:  
        All tablespaces                                   255
        DSNDB01 and DSNDB06                       127

Maximum simple or segmented                    2 gigabytes 
       data set size        
[Top]
No.
제목
작성자
작성일
조회
437DB2 UDB 운용명령어
정재익
2002-10-17
10145
436DB2 UDB V.7 설치가이드
정재익
2002-10-17
8046
435DB2 를 이용한 ASP/JSP 설치 가이드
정재익
2002-10-17
8376
434DB2 Limits
정재익
2002-10-17
9016
433BIND,PLAN,컴파일이 모지?,,,,
정재익
2002-10-17
9033
432PREFORMAT!... 그것이 알고싶다!!!
정재익
2002-10-17
7853
431DB2프로그램코딩예제
정재익
2002-10-17
15349
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2019 DSN, All rights reserved.
작업시간: 0.075초, 이곳 서비스는
	PostgreSQL v11.5로 자료를 관리합니다