About
Topic
Technical development for PeopleSoft PeopleTools:
- PeopleCode
- Online Development
- SQR
- Server Administration
- Databases
- etc.
Goal
The goal of this blog is three-fold:
- Documenting Things I Learn: in case I have to do it again
- Share My Knowledge: in case others happen to attempt the things that I do
- Networking: bulding a network of readers or acquaintances
About Me
I am a PeopleSoft Technical Consultant. I work for a small consulting firm who places me in contracts that generally have started as short term but have extended much longer.
I started my life with computers in middle school. My programming started in eighth grade with Visual Basic. For college, I got a computer science degree, and then, I started programming contracts. At first, I was using Java, but then, I worked my way into SQR and finally PeopleTools.
Hello,
This is Ram working as a PeopleSoft Admin.
Requesting your assistance with the below question:
We have a PeopleSoft application on DB2 database with operating system: AIX
Currently we have the PeopleSoft schema under “arbtadm”, similar to “sysadm” as both ownerid and accessid
I would like to change the ownerid: to “arbpadm” and leave accessid as-is “arbtadm”
How can I do that. Any documents that I can use to accomplish the same.
Thank you.
Regards,
Ram.
Comment by Ram — April 8, 2008 @ 2:58 pm
Ram,
That is a big question. I can’t give you a step by step answer, and I don’t know any resources offhand that might help. But, maybe a few thoughts might give you some ideas.
You can create a project with all of the records:
- Create a new project in App Designer
- Insert > Definitions into project (Ctrl + F7)
- Change the Definition Type to record
- Click the Insert button to load all the records in the system
- Click Select All to select them all in the list
- Click Insert again to insert into the project
- You should probably save the project at this point
You can create a build script by building the project
- Build > Project
- Click the Settings button
- On the Create tab choose: Skip table if it already exists, Recreate view if it already exists, and recreate index if it already exists
- On the Alter tab check: Alter even if no changes (important because you haven’t made any changes to these records)
- On the scripts tab select output to single file
- Click OK to go back to the build dialog
- For the build options: check all the options (Create tables, Create views, Alter tables, etc)
- For the Execute options: choose Build script file
- Click build
Once this completes you should have a script that will rebuild your entire database. From this point, I am guessing you could do something like a search and replace to change arbtadm to arbpadm.
As far as other things you will have to do:
- update the psadmin profiles (both App server and Process schedulers)
- security for tables that the access id needs (not sure off the top of my head — PeopleBooks should have some info here)
Let me know if I can help more. I am not sure if this is what you were asking or not. Hopefully, someone else will chime in if they have any better ideas.
Hope that helps,
Stephen
Comment by digitaleagle — April 9, 2008 @ 4:29 pm