Displaying or updating the owner of resource limit (RLIMIT) ables
You can display or update the owner of the resource limit tables.
Procedure
-
On the DB2 Administration Menu (ADB2) panel, specify
Z, and press Enter.
The System Administration (ADB2Z) panel is displayed.
-
Specify option 2R, and press Enter.
The Resource Limit Tables Owner (ADB2Z2R) panel is displayed, as shown in the following figure.
Figure 1. Resource Limit Tables Owner (ADB2Z2R) panel ADB2Z2R --------------- DD1A Resource Limit Tables Owner -------------- 01:57 Command ===> DB2 System: DD1A Enter the owner of the resource limit tables: Owner ===> SYSIBM
-
Specify the owner of the resource limit tables, and press Enter to display the resource limit
tables owned by that owner, as shown in the following figure.
Figure 2. Display/Update Resource Limit (RLIMIT) Tables panel (ADB2Z2RD) ADB2Z2RD ------ DD1A Display/Update Resource Limit Tables -------- Row 1 of 1 Command ===> Scroll ===> PAGE DB2 System: DD1A Commands: DIS - Display RLIMIT STO - Stop RLIMIT Line commands: S - Display/update STA - Start RLIMIT with ID I - Insert row Select ID Owner Name Columns * * * * ------ -- -------- ------------------ ------- 01 SYSIBM DSNRLMT01 9 01 SYSIBM DSNRLST01 11 ******************************* END OF DB2 DATA *******************************
The following fields are available on this panel:
- SELECT
- Input field where you enter one of the line commands listed on the panel.
- ID
-
RLIMIT identifier.
- OWNER
- Authorization ID of the owner of the RLIMIT table.
- NAME
- Name of the RLIMIT table.
- COLUMNS
- Number of columns in the RLIMIT table.
-
Issue one of the following commands, and press Enter:
- DIS
- Displays the current status of the resource limit. This command is equivalent to the Db2® command DISPLAY RLIMIT.
The following figure shows the RLIMIT status information Db2 Admin Tool returns when you issue the DIS primary command.
Figure 3. Display RLIMIT panel (ADB2DB2O) ADB2DB2O ------- DD1A Browse DB2 Command Output --- Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE -STA RLIMIT ID=01 ********************************* Top of Data ********************************** DSNT704I #DSN9- SYSIBM.DSNRLST01 HAS BEEN STARTED FOR THE RESOURCE LIMIT FACILITY DSNT704I #DSN9- SYSIBM.DSNRLMT01 HAS BEEN STARTED FOR THE RESOURCE LIMIT FACILITY DSN9022I #DSN9- DSNTCSTR 'START RLIMIT' NORMAL COMPLETION ******************************** Bottom of Data ******************************** - STO
- Stops the resource limit. This command is equivalent to the Db2 command STOP RLIMIT.
The following figure shows the information Db2 Admin Tool returns when you issue the STO primary command to stop the resource limit facility.
Figure 4. Stop RLIMIT panel (ADB2DB2O) ADB2DB2O ------- DD1A Browse DB2 Command Output --- Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE -STO RLIMIT ID=01 ********************************* Top of Data ********************************** DSNT702I #DSN9- RESOURCE LIMIT FACILITY HAS BEEN STOPPED. WAS USING SYSIBM.DSNRLST01 DSNT702I #DSN9- RESOURCE LIMIT FACILITY HAS BEEN STOPPED. WAS USING SYSIBM.DSNRLMT01 DSN9022I #DSN9- DSNTCSTP 'STOP RLIMIT' NORMAL COMPLETION ******************************** Bottom of Data ******************************** - S
- The S line command. It displays or updates the resource limit status and the resource limit
status of resource limit table DSNRLMTxx.
The following figure shows the panel returned when you issued the S line command to show the content of the RLIMIT table and used the primary command PRE ON to show the predictive governor columns too.
Figure 5. Display RLIMIT panel (ADB2Z2RS) ADB2Z2RS ---- DD1A Display/Update Resource Limits ID=01 ---------- Row 1 of 1 Command ===> Scroll ===> PAGE DB2 System: DD1A Line commands: D - Delete I - Insert U - Update F Reactive B u Govenor i n Service n Select Auth ID Plan Collection Package LU Name c Units d * * * * * * * * ------ -------> -------- -----------------> -------> -------> - ----------- - ? VNDOKAV COL1 PACK1 LU1 1 ? N VNDOKAV XCOLL XPACK XLU 1 ? VNDOKAV YCOLL YPACK YLU 1 ? VNDWLB1 WLBCOLLECTION WLBPACKA WLBLU 1 ? ******************************* END OF DB2 DATA *******************************
The following figure shows the panel returned when you issue the S line command to show the column values of DSNRLMTxx resource table.
Figure 6. Display RLIMIT panel (ADB2Z2RM) ADB2Z2RM ---- DD1A Display/Update Resource Limits ID=01 ----- Row 1 to 2 of 2 Command ===> Scroll ===> PAGE DB2 System: DD1A Line commands: D - Delete I - Insert U - Update F Reactive u Governor n Service Select User ID Appl Name Wrkstn Name IP c Units * * * * * * ------ -------> ---------------> -------------> --------------> - --------- ? SMITHJR APPL1 WORKSTATN1 30 PAUL 125.123.123.123 8 10 ******************************* END OF DB2 DATA *******************************
- STA
- Starts the resource limit with ID.
The following figure shows the information Db2 Admin Tool returns when you issue the STA line command to start the resource limit facility with a particular ID.
Figure 7. Start RLIMIT panel (ADB2DB2O) ADB2DB2O ------- DD1A Browse DB2 Command Output --- Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE -STA RLIMIT ID=01 ********************************* Top of Data ********************************** DSNT704I DB2X SYSIBM.DSNRLST01 HAS BEEN STARTED FOR THE RESOURCE LIMIT FACILITY DSN9022I DB2X DSNTCSTR 'START RLIMIT' NORMAL COMPLETION ******************************** Bottom of Data ******************************** - I
- Inserts rows into the resource limit table and inserts or updates column values for the
DSNRLMTxx resource limit table.
The following figure shows the output when you enter the I line command in front of a row from the RLIMIT table in Figure 5. On the Insert RLIMIT panel, as shown in the following figure, you can enter values for a new row in the RLIMIT table.
Figure 8. Insert RLIMIT panel (ADB2Z2RU) ADB2Z2RU -------------------- DD1A Insert RLIMIT ----------------------- 12:05 Command ===> DB2 System: DD1A DB2 SQL ID: ADM001 More: + Enter/verify details for auth_id.DSNRLSTxx: Auth id . . . . . > (blank: all) Plan name . . . . (blank: all) Collection . . . . > (blank: all) Package . . . . . > (blank: all) LU name . . . . . > (blank: local, PUBLIC: all remote) Function . . . . . (1 - BIND operations 2 - react gov of dyn SQL by package 3 - disable query I/O parallelism 4 - disable query CP parallelism 5 - disables sysplex parallelism 7 - predict. gov. of dyn SQL by pkg) A - react gov of status SQL by package Service units . . NULL (react. gov. limit: 0-2147483647) Bind allowed . . . (No, for function 1) PG warn limit . . NULL (predic. gov. warning limit serv. units PG err limit . . . NULL (predic. gov. error limit service units PG cat B act . . . (Execute, Reject, or Warn) Press ENTER to Insert RLIMIT, or press PF3 to cancel Insert.
The following figure shows the output when you enter the I line command in front of a row from the DSNRLMTxx RLIMIT table in panel ADB2ZRM.
Figure 9. Insert RLIMIT panel (ADB2Z2RI) ADB2Z2RI -------------------- DD1A Insert RLIMIT ----------------------- 12:05 Command ===> DB2 System: DD1A DB2 SQL ID: ADM001 Enter/verify details for auth_id.DSNRLMTxx: User id . . . . . > (blank: all) Application name . > (blank: all) Workstation name . > (blank: all) IP address . . . . > (blank: all) Function . . . . . (8 - react gov of dyn SQL by client info 9 - pred gov of dyn SQL by client info B - react gov of static SQL by client info) Service units . . NULL (react. gov. limit: 0-2147483647) PG warn limit . . NULL (predic. gov. warning limit serv. units) PG err limit . . . NULL (predic. gov. error limit service units) PG cat B act . . . (Execute, Reject, or Warn) Press ENTER to Insert RLIMIT, or press PF3 to cancel Insert
The information that Db2 Admin Tool returns to you from the commands is in ISPF browse format.