| | |
|---|
TP Definition: Partitioned table space Description: Estimates the reorganized space for a partitioned table space | rc = ASURXSE('TP' db2ver card pqty sqty partitions pctfree freepage pgsize dssize rowavg maxrows compress devtype alocunit type segsize); where: - TP = the literal ‘TP’
- db2ver = Db2 version
- card = number of rows in partition
- pqty = primary quantity in allocation units
- sqty = secondary quantity in allocation units
- partitions = number of partitions
- pctfree = percentage of free spacefree
- page = free pages
- pgsize = size of page (4, 8, 16, or 32)
- dssize = maximum size of a data set in kilobytes
- srowavg = average row length
- maxrows = maximum rows per page for table space
- compress = data compression (Y or N)
- devtype = device type (for example, 3390)
- alocunit = allocation unit (C or T)
- type = type of table space (L, I, K, R, or 1 where 1 indicates blank or not specified) 1
- segsize = number of pages in the segment 1, 2
| SERESULT = TP rpp pages space trks cyls extents dsns, where: - TP = the literal 'TP'
- rpp = rows per page
- pages = number of pages in partition
- space = space in KB
- trks = space in tracks
- cyls = space in cylinders
- extents = number of extents
- dsns = number of data sets
Important If you omit the type and segsize parameters, the product assumes the type is a simple table and the segment size is 0. Specifying 1 for the type parameter is the equivalent of specifying a blank in the online interface. You must specify a non-zero value for the segsize parameter if you set the type parameter to R. If the type parameter is R and you specify a 0 value for segsize or omit the segsize parameter, DASD MANAGER PLUS sets the default segment size to 4. |
TB Definition: Non-partitioned table Description: Estimates the reorganized space for a nonpartitioned table | rc = ASURXSE('TB' db2ver card pctfree freepage pgsize rowavg compress segsize maxrows); where - TB = the literal ’TB’
- db2ver = Db2 version
- card = number of rows in table
- pctfree = percentage of free space
- freepage = free pages
- pgsize = size of page (4, 8, 16, or 32)
- rowavg = average row length
- compress = data compression (Y or N)
- segsize = segment size
- maxrows = maximum rows per page for table space
| SERESULT = TB rpp pages; where: - TB = the literal ‘TB’
- rpp = number of rows per page
- pages = number of pages in the table
|
TS Definition: Non-partitioned table space Description: Estimate the reorganized space for a nonpartitioned table space | rc = ASURXSE('TS' db2ver pages pqty sqty freepage pgsize compress segsize devtype alocunit type); where - TS = the literal ‘TS’
- db2ver = Db2 version
- pages = total pages for all tables
- pqty = primary quantity in allocation units
- qty = secondary quantity in allocation units
- sfreepage = free pages
- pgsize = size of page (4, 8, 16, or 32)
- compress = data compression (Y or N)
- segsize = segment size
- devtype = device type (for example, 3390)
- alocunit = allocation unit (C or T)
- type = type of table space (L, I, K, or blank)
| SERESULT = TS pages space trks cyls extents dsns; where: - TS = the literal 'TS'
- pages = total pages for all tables
- space = space in KB
- trks = space in tracks
- cyls = space in cylinders
- extents = number of extents
- dsns = number of data sets
|
TS Definition: Partition-by-growth table space Description: Estimates the reorganized space for a partition-by-growth table space | rc = ASURXSE('TS' db2ver pages pqty sqty freepage pgsize compress segsize devtype alocunit G rpp dssize card); where - TS = the literal ‘TS’
- db2ver = Db2 version
- pages = total pages for all tables
- pqty = primary quantity in allocation units
- sqty = secondary quantity in allocation units
- freepage = free pages
- pgsize = size of page (4, 8, 16, or 32)
- compress = data compression (Y or N)
- segsize = segment size
- devtype = device type (for example, 3390)
- alocunit = allocation unit (C or T)
- type = type of table space (G)
- rpp = rows per page
- dssize = maximum size of a data set in kilobytes
- card = number of rows in table
| SERESULT = TS parts pages space trks cyls extents dsns pages2 space2 trks2 cyls2 extents2 dsns2 card card2; where: - TS = the literal ‘TS’
- parts = total number of partitions
- pages = total pages per partition 3
- space = KBs per partition 3
- trks = tracks per partition 3
- cyls = cylinders per partition 3
- extents = extents per partition 3
- dsns = data sets per partition 3
- pages2 = pages in the last partition
- space2 = KBs in the last partition
- trks2 = tracks in the last partition
- cyls2 = cylinders in the last partition
- extents2 = extents in the last partition
- dsns2 = data sets in the last partition
- card = rows per partition 3
- card2 = rows in the last partition
|
IP index Definition: Estimates the reorganized space for an index | rc = ASURXSE('IP' db2ver card rpk pqty sqty parts avgkeylength nlavgkeylen pctfree freepage piecesize uniquerule indextype compress devtype allocunit typets pgsize); where - IP = the literal ‘IP’
- db2ver = Db2 version
- card = number of rows in table
- rpk = rows per key
- pqty = primary quantity in allocation units
- sqty = secondary quantity in allocation units
- parts = number of partitions
- avgkeylength = average length of key
- nlavgkeylen = average length for nonleaf page key
- subpages = number of subpages
- pctfree = percentage of free space
- freepage = free pages
- piecesize = file size for ix
- uniquerule = unique rule
- indextype = index type (2)
- compress = data compression (Y or N)
- devtype = device type (for example, 3390)
- allocunit = allocation unit (C or T)
- typets = type of table space (G, R, L, 1 (1 indicates blank or not specified))
- pgsize = size of eaf pages in the index (4, 8, 16, or 32)
Important If you omit the typets and pgsize parameters, the product assumes that the type is a nonlarge table space and the page size is 4. Specifying 1 for the typets parameter is the equivalent of specifying a blank in the online interface. | SERESULT = IP pages space trks cyls nlevels extents dsns; where: - IP = the literal ‘IP’
- pages = number of pages in the index
- space = space in KB
- trks = space in tracks
- cyls = space in cylinders
- nlevels = number of levels for the index
- extents = number of extents
- dsns = number of data sets
|