DB2 used for automating scripts to a separate database

[Vivian2002]

Hi,

Background information: Using 2 servers, 1 has DB2 installed the other is where the database resides. I have very limited access to the server that the database is on.

Objective: Trying to write a script that will automatically query the database every week for some data, take that data and put it into a another database that I will create.

Question: Can I use DB2 to help me write this automation type script? And if so or if not can you point me to some references that will help me accomplish this?

Thank You,

Vivian

 

[pganesh5]

Hi Vivian,

Below information help you.
If you are using db2 udb then.

1) Goto Command Center in Menu bar in Tools you will see the Script Center,Click on that and give the information about database ,instance ,name of the script and place ect. and write your script whatever you want below box(exe:-sql statement like insert or update whatever ) and hit ok.

2)Goto Journal in Tools in Menu Bar in Command center.
You will see the your script if u select the system name in pending jobs.

3)Highlight the script below and right click and click on Reshedule and select the weekly or daily whatever u want.

PN:-if your using unxi then oscommand else select db2command
in script center.

Hope this may help you
Thank you
Ganesh

 

[Vivian2002]

Thank You Ganesh..

Vivian