1 |
• |
[OWNER/PWD@DATABASENAME] Replace with the correct values for the PeopleSoft® schema owner/password and staging database. |
• |
[SPOOLPT] Replace with the directory for the session log. |
• |
[PTAPP] Replace with the tablespace for the staging table |
• |
[PSINDEX] Replace with the tablespace for the staging table indexes |
3 |
Run the modified script via Sql*Plus or Toad® in the PeopleSoft staging database as the PeopleSoft schema owner |
1 |
2 |
Find and replace the variable [DATABASENAME] with the name of the database. |
3 |
4 |
Execute the script corresponding to your DB2® platform:
• |
1 |
Locate the StageDB2-ZOS-856.sql script in the scripts\DB2\Staging folder. |
Replace with the name of the tablespace for the new table STAT_STAGE_CNTRL. | |
Replace with the creator/owner id. Requires the [USERID] to be able to set current sqlid to this [CREATORID] secondary authorization RACF group. Would need to connect [USERID] to the RACF group [CREATORID]. | |
Replace with the Stogroup name for the index. Requires the grant GRANT USE OF STOGROUP [STOGRPNAME] TO [CREATORID] |
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center