Stoping & Restarting Repository Database while server ba

Oritech · Post by **Oritech** » Fri May 15, 2009 12:27 am

Just now system Administrator of server (Windows Based) where our Infoshpere is installed with its repository on DB2 Database,

has asked us how to Stoping & Restarting Repository Database (DB20) from command line so that it can be put in scripts which can run while backing up the server.

I am wondering do we really need to do this or this should happen automatically.....

Please advice.
Thanks

ray.wurlod · Post by **ray.wurlod** » Fri May 15, 2009 1:00 am

You really need to do it, and you really do need to shut down (and, of course, start) the servers in the correct order. Shutting down DB2 while WAS and DataStage server are still running will cause you no end of grief.

Oritech · Post by **Oritech** » Fri May 15, 2009 1:25 am

Thank ray,

I understand the steps to be followed are

1) Stop DataStage
2) Stop the ASB agent
3) Stop Websphere Application Server
4) Stop the database instance for the XMETA repository

Back up the server

5) Start the database instance for the XMETA repository
6) Start Websphere Application Server
7) Start the ASB agent

Start DataStage

In order to automate all the steps ie 1 to 8,

System Admin is asking for the command line instuctions which can be put in scripts & scheduled before & after the back up server .

Where these commands/procedure can be found?

thanks

Oritech · Post by **Oritech** » Sun May 17, 2009 5:00 pm

Just wondering If any one know the command line instuctions for stoping & starting the repository database & engine...

Please share...

chulett · Post by **chulett** » Sun May 17, 2009 5:12 pm

Sorry, don't know. Why not ask your official support provider? Once you get the answer, please share it back here.

ray.wurlod · Post by **ray.wurlod** » Sun May 17, 2009 8:13 pm

There are scripts in ASBNode/bin and ASBServer/bin but I can't remember off the top of my head what they are. Hopefully the locations will trigger someone who does know to respond. If not, I'll get back to it at a convenient opportunity.

pxraja · Post by **pxraja** » Mon May 18, 2009 12:00 am

Oritech wrote:Thank ray,

I understand the steps to be followed are

1) Stop DataStage
2) Stop the ASB agent
3) Stop Websphere Application Server
4) Stop the database instance for the XMETA repository

Back up the server

5) Start the database instance for the XMETA repository
6) Start Websphere Application Server
7) Start the ASB agent
Start DataStage

In order to automate all the steps ie 1 to 8,

System Admin is asking for the command line instuctions which can be put in scripts & scheduled before & after the back up server .

Where these commands/procedure can be found?

thanks

Here is the commands to stop and start the datastage server which we are using....

1. ensure no jobs are running
2. go to the path ../IBM/InformationServer/Server/DSEngine
3. ./bin/uv -admin -stop /*to stop datastage*/
4. go to the path ../IBM/WebSphere/AppServer/bin
5. ps -ef | grep java /* to ensure the path of was*/
6. ./stopServer.sh server1 -user wasadmin -password ******
7. su - db2inst1 /* change to db2 user */
8. db2stop /* to stop db2 database manager */
9. do your backup process
10. su - db2inst1
11. db2start
12. go to the path ../IBM/WebSphere/AppServer/bin
13. ./serverStatus.sh server1 -user wasadmin -password wasadmin /* to check the WAS server status */
14. ./startServer.sh server1 -user wasadmin -password ******
15. go to the path ../IBM/InformationServer/Server/DSEngine
16. ./bin/uv -admin -start /*to start datastage*/

please make a note that if any thing you missed out the sequence then you will be having trouble in bringing up the datastage server or it may be corrupted.

please have the assistance of WAS admin or DATASTAGE administrator involved in the process

pxraja · Post by **pxraja** » Mon May 18, 2009 12:08 am

Hi

the mentioned commands were used in AIX server did not noticed the datastage server is installed in windows environment..

any how I would not suggest the same will work in windows environment or not

ray.wurlod · Post by **ray.wurlod** » Mon May 18, 2009 12:19 am

The commands will work OK on Windows assuming that the user ID executing the script has relevant authority.

db2Start and db2Stop are in %SQLLIB%\BIN (for example C:\IBM\SQLLIB\BIN).

WebSphere Application Server commands such as startServer and stopServer are in C:\IBM\WebSphere\AppServer\bin folder.

The uv command for stopping/starting DataStage is in the DataStage engine bin directory (for example C:\IBM\Information Server\Server\DSEngine).