Solution:
1. Create a schema called eg.: SYSDEV.
2. Import the PSTools demo schema into SYSDEV schema.
3. Logon to the db and query for PSDBOWNER table. There should be one row with a dbname and ownerid.
4. Run the following DML:
INSERT INTO PSDBOWNER ( DBNAME, OWNERID ) VALUES ('P858SP01', 'SYSDEV');
You can give the dbname anything you like, but the ownerid has to be SYSDEV since you just created a new schema under SYSDEV
5. Issue the following DML to change ownerid in the psstatus table, the symbolicid in the psoprdefn table and the accessid in psaccessprfl.
UPDATE SYSDEV.PSSTATUS SET OWNERID = 'SYSDEV';
UPDATE SYSDEV.PSOPRDEFN SET SYMBOLICID = 'SYSDEV', OPERPSWD = OPRID, ENCRYPTED= 0;
UPDATE SYSDEV.PSACCESSPRFL SET ACCESSID = 'SYSDEV', SYMBOLICID = 'SYSDEV', ACCESSPSWD = 'SYSDEV', VERSION = 0, ENCRYPTED = 0;
6. Logon to Data Mover as SYSDEV/password and run the encrypt.dms provided by Peoplesoft.