How to run the VERSION AE and SETSPACE.SQR process for populating Tablespaces in App designer

1. To run the VERSION AE program for Oracle on your database.
(It is found in PS_HOME\bin\client\winx86.)
From the DOS command line, the syntax is:
psae -CD -CT ORACLE -CO -CP -R INSTALL -AI VERSION

2. The SETSPACE SQR identifies the tables with an invalid database name/Tablespace combination.
This step populates all Tablespace information in the PSRECTBLSPC table.
The values stored in the DDLSPACENAME field are updated with current values found in the system catalog for tables already defined in your database. If you modified Tablespace names from the PeopleSoft-delivered names, this step makes those same changes in the PeopleSoft record definition.
If you receive any errors when you run this script, correct them by creating the needed Tablespace or changing the Tablespace definition on the record object. Then run the script again to validate that you have created all Tablespaces.

A.To run setspace.sqr in windows
open sqrw(It is found in PS_HOME\bin\client\winx86.), pass dbname, username, password and in argument section pass the following argument assuming d:\pt847 is your PS_HOME
-Id:\pt847\sqr\
-ZIFd:\pt847\sqr\pssqr.ini

B.On unix use the below
Export PS_HOME=/u02/app/PT847
Export REPNAME=/u02/app/PT847/sqr/dddaudit.sqr
Export DB=sysadm/passw0rd@HRDEMO
Export SQR=$PS_HOME/bin/sqr/ORA/bin/sqr
$SQR $REPNAME $DB -I$PS_HOME/sqr/ -F/tmp/ -ZIF$PS_HOME/sqr/pssqr.ini
SQR for PeopleSoft V8.47
Database Name (Optional, Press ENTER to continue): HRDEMO
Process Instance (Optional, Press ENTER to continue): 2
Operator ID (Optional, Press ENTER to continue): PS
Run Control (Optional, Press ENTER to continue): r2

SQR for PeopleSoft: End of Run.
[/u02/app/PT847/bin/sqr/ORA/bin]
The output of this file will be in /tmp folder coz we have given -F/tmp/, so there in /tmp it will create a lis file ex:dddaudit.lis