Chat now with support
Chat with Support

Stat 6.2 - Upgrade Notes

PeopleSoft on DB2

Execute the script corresponding to your DB2® platform:

•
Mainframe
•
AIX/UNIX

Mainframe

1
Locate the StageDB2-ZOS-856.sql script.
2
Find and replace the following variables.
Table 1. Mainframe variables
Variable
Replacement

[DATABASENAME1]

Replace with the name of the database.

[TABLETBSPC1]

Replace with the name of the tablespace for the new table STAT_STAGE_CNTRL.

Usually use an existing tablespace, so DB2 utilities that run at the tablespace level do not have to be modified for the new tablespace (example: image copy).

[DATABASENAME2]

Replace with the name of the database.

[CREATORID]

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].

[STOGRPNAME]

Replace with the Stogroup name for the index.

Requires the grant GRANT USE OF STOGROUP [STOGRPNAME] TO [CREATORID]

AIX/UNIX

1
Locate the StageDB2-UNIX-856.sql script.
2
Find and replace the following variables:
Table 2. AIX®/UNIX® variables
Variable
Replacement

[DATABASENAME]

Replace with the name of the database.

[USERID]

Replace with the correct user access id.

[PASSWORD]

Replace with the correct access password.

[TABLETBSPC]

Replace with tablespace for the table.

[CREATORID]

Replace with the creator/owner ID of the tables.

Install the Stat Client

Before installing the Stat® Client, please note that the user performing the installation or de-installation needs to be logged in as an Administrator locally on that server/workstation due to enhanced security on Windows®.

The Stat Client can be installed locally or it can be installed to a single network location. For detailed instructions, see the Stat Install Notes document. You can open this document from the Stat Autorun program by clicking View Install Notes.

To install the Stat Client:
1
Select the 32-bit or the 64-bit Stat Windows Client and click Install Stat Windows Client to launch the InstallShield Wizard for Stat 6.2.0.
2
Complete the steps for installing the Stat Client locally. See the Stat Install Notes document for more information.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating