Estimating the space requirements for a table space
- On the BMC AMI Change Manager for Db2 Main Menu, select WORKID, and press Enter.
- On the WORKID Action Menu, type the name of the WORKID or type a wildcard pattern to display a list of work IDs. Then, select Specify Db2 definitions and press Enter.
- On the Object Specification panel, specify the name of a table space (or use wildcard characters) and press Enter.
- On the Mixed List panel, type E in the Act column to edit a table space (TS) object and press Enter.
On the Tablespace Detail panel, type S to select Space Estimation and press Enter.
- On the Tablespace Estimation panel (nonpartitioned), you can modify the values for the fields.
To estimate the space for a nonpartitioned table space, you can complete one of the following steps:
DEJM ALTER ---------------------- Tablespace Estimation ---------------------
Command ===> Scroll. . PAGE
Tablespace Name: S1BASIC.T03AMSEG
Pagesize . . : 16 |------- Estimated -------|
Segsize . . . . 16 (0-64) | Pages : 34 |
Priqty . . . . 1440 | Space : 576 K |
Secqty . . . . 128 | NbrSec : 0 |
Allocation Unit K (K,C,T) |-------------------------|
Device Type . . 3390
Freepage . . . 0 (0-255) Percent Compressed . . . 0 (0-99)
Pctfree . . . . 0 (0-99) Pctfree Update . . . . . 0 <DEFLT>,0-99
Compress . . . . N (Y,N,H,F) Lines 1 to 2 of 2
Maxrows . . . . 255 More: >
(CO=Columns) -Row Length- Avg -- Estimated --
Ac Owner Table Name Max Avg Orig NbrRows Rws/Pg Pages
************************************ TOP **************************************
S1BASIC T_T03AMSEG_A 1234 791 Proj 0 20 16
S1BASIC T_T03AMSEG_B 206 155 Proj 0 109 16
*********************************** BOTTOM ************************************- Modify the values for the Avg Row Length (average row length) or the Nbr Rows (number of rows) field in the lower portion of the panel for a table in the table space.
Type CO in the Ac column. In the Average Row Length panel that is displayed, type over the values for Average to Use in Estimate. Then press END.
ALUSCOSE R -------------- Average Row Length -------------------------------
Command ===> Scroll. . PAGE
Table Name . . . . . . . . . . . . : DEMOLAB1.DEMO030T
Row Length
Maximum . . . . . . . . . . . . . : 578
Averages
Projected . . . . . . . . . . : 578
BMCSTATS . . . . . . . . . . . : 0
RUNSTATS . . . . . . . . . . . : 0
Average to Use in Estimate . . . . 578
Lines 1 to 8 of 100
More: +
-- Defined -- Projected
Column Name Column Type Length Null Length
************************************ TOP **************************************
SSSNO CHAR 9 Y 10
EMPNO CHAR 9 N 9
EMPNAME CHAR 40 Y 41
EMPDEPT CHAR 4 Y 5
EMPDEPTNAME CHAR 36 Y 37
EMPHIREDATE DATE N 4
EMPDOB DATE Y 5
EMPAGE SMALLINT Y 3
To estimate the space for a partitioned table space, you can complete one of the following steps:
ALUSTPSE R --------------- Tablespace Estimation (Partitioned) --------------
Command ===> Scroll. . PAGE
Tablespace Name : DEMOCRJ.P7 Commands: CO CANCEL
Pagesize . . . : 4 |------ Estimated -------|
| Pages : 14 |
TB Name . . . . : RDACRJ.'tbp1a' | Space : 336 K |
Max Row Len . . : 104 |------------------------|
Maxrows . . . . . 255 (1-255)
Dssize . . . . . 0 G
Percent Compressed . . . 0 (0-99)
Lines 1 to 7 of 7
(CO=Columns, PA=Propagate Attributes, PE=Propagate Est) More: >
-- Row Length --
Logical Aloc Avg Comp --- Estimated ---
AC Part NbrRows PriQty SecQty Unit Avg Orig Avg Space NbrSec
************************************ TOP **************************************
1 0 -1 -1 K 97 Proj 97 48 K 0
2 0 -1 -1 K 97 Proj 97 48 K 0
3 0 -1 -1 K 97 Proj 97 48 K 0
4 0 -1 -1 K 97 Proj 97 48 K 0
5 0 -1 -1 K 97 Proj 97 48 K 0
6 0 -1 -1 K 97 Proj 97 48 K 0
7 0 -1 -1 K 97 Proj 97 48 K 0- Modify the values for the NbrRows (number of rows), PriQty (primary quantity), SecQty (secondary quantity), Aloc Unit (allocation unit), or Avg Row Length (average row length) field. Scroll right to modify the values for Devt (device type), Free Page, Pct Free, Comp (compression), (BMC.DB2.SPE2210) Dssize Part (DSSIZE for the partition of a partition-by-range table space with relative page format), Rows/Page, and Pct Upd (percentage of free space).
To change the values for the NbrRows, PriQty, SecQty, and Aloc Unit fields for all the partitions in the table space, type PA in the Ac column adjacent to the partition you want to propagate. In the displayed Space Estimation Attribute Propagation panel, type over the values you want to change. Then press END.
ALUSTPSE R --------------- Tablespace Estimation (Partitioned) --------------
Command ===> Scroll. . PAGE
Tab --------------------------------------------------------------------- NCEL
Pag | ALUSPASE Space Estimation Attribute Propagation | ----|
| Command ===> | |
TB | | K |
Max | Tablespace Name : DEMOCRJ.P7 | ----|
Max | Device Type . . : 3390 |
Dss | |
| |
| Make any changes necessary or blank out to leave current value; | f 7
(CO | changes will be applied to all parts where applicable. | >
| |
L | ALOC | ---
AC | NBRROWS PRIQTY SECQTY UNIT | brSec
*** | 0 -1 -1 K | *****
pa | | 0
| | 0
| Commands: END CANCEL | 0
| } 0
--------------------------------------------------------------------- 0
6 0 -1 -1 K 97 Proj 97 48 K 0
7 0 -1 -1 K 97 Proj 97 48 K 0To propagate the space estimates to the PriQty field for a specified partition, type PE in the Ac column.
To estimate the space for a partition-by-growth table space, you can modify the value of the Maxpartitions, Avg Row Len, or Nbr of Rows fields in the upper portion of the panel. The fields in the lower portion of the panel are read only.
DEHJ ALTER ----------- Tablespace Estimation (Partition By Growth) ----------
Command ===> Scroll. . PAGE
Tablespace Name: R1BASIC.TRT10AIM
TB Name . . . : R1BASIC.T_T10AIM
Pagesize . . . : 8 Max Row Len . : 1255
Segsize . . . . 32 (1-64) Avg Row Len . . 843 Proj
Priqty . . . . . -1 Comp Row Len . : 843
Secqty . . . . . -1 Nbr of Rows . . 0
Allocation Unit K (K,C,T) |------------ Estimated ------------|
Device Type . . 3390 | Pages : 4 |
Freepage . . . . 0 (0-255) | Space : 48 K |
Pctfree . . . . 5 (0-99) | Parts Needed : 1 |
Pctfree Update . 0 <DEFLT>,0-99 | Rows/part : 0 |
Compress . . . . N (Y,N,H,F) | in last part : 0 |
Maxrows . . . . 255 | NbrSec/part : 0 |
Dssize . . . . . 4 G | in last part : 0 |
Pct Compressed . 0 (0-99) |-----------------------------------|
Maxpartitions . 256 More:
Avg
Part NbrRows Avg Orig Space Rows/Page
************************************ TOP **************************************
1 0 843 Proj 0 9
*********************************** BOTTOM ************************************
- Press Enter.The new space estimates for the number of pages, amount of space, or number of secondary allocations are displayed.
- When you finish reviewing estimates, modify the values for the nonpartitioned table space in the upper left-hand portion of the panel, and press Enter. The values that you can modify are described in this topic.
When you have finished updating the fields, press END until the Mixed List panel is displayed.
ALUSMXL ER --------------------------- Mixed List ---------------------------
Command ===> Scroll. . PAGE
WORKID . . . . : RDACRJ.ALTER Commands: CANCEL
Type action next to object and press Enter.
E=Edit L=Like D=Drop U=Undo
Objects 112 to 125 of 227
More: - +
Act Object-Type Objects
*$ TB . . . . RDACRJ 'tbp1a'
FK . . . RDACRJ 'tbp1a' P1AX1
IXC. . . RDACRJ IXP7A__C
IXP. . . RDACRJ IXP7A_2
UCP. . RDACRJ 'tbp1a' ' TP1A C4 1'
AL . . . RDACRJ ALP1A__C
TS . . . . . DEMOCRJ ROBBINS
TB . . . . RDACRJ JGSD004_A17_LOWC
TB . . . . RDACRJ JNMP007_BO_HEADER
TB . . . . RDACRJ JNMP029_BO_CMDTY
TS . . . . . DEMOCRJ SF1
TS . . . . . DEMOCRJ SF1X
TS . . . . . DEMOCRJ S1
TB . . . . RDACRJ TBS1A- Press END until the WORKID Action Menu is displayed.Now that the space requirements for a table space have been estimated, you can analyze a work ID and execute a worklist.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*