DSXchange

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

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.

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

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

Please share...

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

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.

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

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

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).