CODEWITHSUNDEEP
databasedb2udb
StackUser
StackUser

Reputation: 5398

Deploy stored procedure scripts to mulitple Databases and instances in DB2

I am new to DB2/UDB. I have a 3 instances each instance have different number of databases below.

instance_1 - 20 databases
instance_2 - 18 databases
instance_3 - 16 databases

Totally I have 54 DBs. All are in sync now. I have developed a stored procedure for a requirement. I have to deploy this stored procedure to all 54 databases. I am doing it manually (54 times). It is very hard to do and it leads to human errors.

Can anyone suggest a tool / approach to do this process automatically.

Upvotes: 0

Views: 129

Answers (0)

Related Questions