DB2 Server for VSE & VM: Control Center Operations Guide for VM

|Appendix K. DB2 UDB Web Control Center Support

|DB2 UDB's Web Control Center can be used to perform certain tasks |against a DB2 Server for VSE & VM database. However, some of these |tasks require processing that must be done locally. Control Center for |VM provides stored procedures that are used to do this local |processing. These stored procedures are invoked to process Web Control |Center commands such as Reorganize Index and Rebind Package.

|Web Control Center stored procedures support requires version 7 or greater |of DB2 UDB, DB2 for VM, and Control Center for VM.

|Perform the the process described in Installing DB2 Web Control Center Stored Procedures only if you are planning to use DB2 Web Control |Center.

|Installing DB2 Web Control Center Stored Procedures

|Installing the Web Control Center stored procedures |consists of three steps: |

1. |Defining the Web Control Center stored procedures (CREATE PROC) to the |database (USER STEPS to Define (CREATE PROC) Stored Procedures)
2. |LOADing the Web Control Center package into the database (USER STEPS to Load the Package)
3. |Generating (GENMOD) the Web Control Center stored procedure MODULEs from |TEXT files (USER STEPS to GENMOD the Stored Procedures) |

|USER STEPS to Define (CREATE PROC) Stored Procedures

|A stored procedure machine (PSERVER) must already be |defined (CREATE PSERVER) to the database before executing the following |steps: |

1. |Logon to the user ID with DB2 for VM Database Administration authority and |Control Center for VM Database Administrator or greater authority.
2. |LINK and ACCESS to Control Center code disk in READ mode (RR).
3. |COPYFILE ARISVEF MACRO from Control Center code disk to ARISVEF DBSU |A.
4. |COPYFILE ARISCCF MACRO from Control Center code disk to ARISCCF DBSU |A.
5. |Modify ARISVEF DBSU as required (see file).
6. |Modify ARISCCF DBSU as required (see file).
7. |Execute: SQMSPGEN dbmach DEFINE ARISVEF A
8. |Execute: SQMSPGEN dbmach DEFINE ARISCCF A
9. |Verify that the stored procedure has been defined. From a user ID |with Control Center for VM Database Administrator or greater authority, |execute the following:

   |EXECUTE: SQM dbmach SHOW PROC ARISVEF
   |EXECUTE: SQM dbmach SHOW PROC ARISCCF

   |

|USER STEPS to Load the Package

1. |Logon to the user ID with DB2 for VM Database Administration authority and |Control Center for VM Database Administrator or greater authority.
2. |LINK and ACCESS to Control Center code disk in READ mode (RR).
3. |Get the PASSWORD for user SQLDBA. |
   1. |Execute DBINIT to database:

      |DBINIT dbmach

   2. |Execute: isql
   3. |Execute: select * from system.sysuserauth where name = |'sqldba'
   4. |Remember the password for SQLDBA.
   5. |Exit from isql. |
4. |At the CMS command prompt, execute: SQLSPGEN dbmach |LOAD ARIS7VE fm sqldbapw, where dbmach is the database |machine ID, fm is the file mode of the ARIS7VE PACKAGE on the Control |Center code disk, and sqldbapw is the PASSWORD for user |SQLDBA.
5. |Verify that the ARIS7VE PKGLIST file and ARIS7VE PKGDBSU exist.
6. |Erase the ARIS7VE PKGDBSU file; it contains the password for |SQLDBA. |

|USER STEPS to GENMOD the Stored Procedures

1. |Log onto the PSERVER machine.
2. |LINK and ACCESS to Control Center code disk in READ mode (RR).
3. |LINK and ACCESS to your LE environment disk in READ mode (RR).
4. |COPYFILE ARISVEF TEXT from Control Center code disk to ARISVEF TEXT |A.
5. |COPYFILE ARIS7VE TEXT from Control Center code disk to ARIS7VE TEXT |A.
6. |COPYFILE ARISCCF TEXT from Control Center code disk to ARISCCF TEXT |A.
7. |Execute: SQMSPGEN dbmach GENMOD ARISVEF A
8. |Execute: SQMSPGEN dbmach GENMOD ARISCCF A
9. |Verify that the ARISCCF MODULE and the ARISVEF MODULE have been |created. |