Chat now with support
Chat with Support

Stat 6.1 - Upgrade Notes

PeopleSoft on DB2

Execute the script corresponding to your DB2® platform:

•
Mainframe
•
AIX/UNIX

Mainframe

1
Locate the StageDB2-OS390-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 6.1.0: 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.1.0.
2
Complete the steps for installing the Stat Client locally. See the Stat 6.1.0: Install Notes document for more information.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating