check pending status
Moderators: chulett, rschirm, roy
check pending status
We use a star schema table structure. Once we load the "child" table, it gets put into check pending status. Right now one of our DBA's has to submit a DB2 command "set integrity" to get it out of check pending status. Is there a way in Datastage to get out of this check pending status? Is there a stage or something that we can set up to run in a datastage job?
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Only if your job is running as a user with DBA privilege could it perform any DBA commands.
Probably the easiest thing to do is to create a shell script (or invoke a stored procedure) that executes with DBA privilege and performs the set integrity operation.
Probably the easiest thing to do is to create a shell script (or invoke a stored procedure) that executes with DBA privilege and performs the set integrity operation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
dsxuserrio
- Participant
- Posts: 82
- Joined: Thu Dec 02, 2004 10:27 pm
- Location: INDIA
You can do as Ray says. Plus you can ask the DBA to write a script for you. You will be given permission to perform a DBA task using your id ( member of dstage ) through that script only. I think they will do a su - inside that script.
We used to do that for truncating DB2 tables using insert_replace and other activities for which we did not have privileges as ourselves.
Talk to your DBA.
We used to do that for truncating DB2 tables using insert_replace and other activities for which we did not have privileges as ourselves.
Talk to your DBA.
dsxuserrio
Kannan.N
Bangalore,INDIA
Kannan.N
Bangalore,INDIA