[AD]DB2 Reorg Pending automation

Steen Rasmussen

[AD]DB2 Reorg Pending automation
If you want supreme automation of reorgs based on ANY condition, CA technologies offers CA Database Analyzer. If you want a tech chat please contact me offline.

Steen Rasmussen
CA technologies

From: Rahul Singh [mailto:[login to unmask email]
Sent: Thursday, January 18, 2018 12:58 PM
To: [login to unmask email]
Subject: [DB2-L] - DB2 Reorg Pending automation

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi Experts

I have a situation where I am being asked to automate execution of DB2 REORG if table is in "Reorg Pending" status. I can easily do this using shell script of windows batch file , however I don't have that option. Only option for me is to automate this using SQL

I am basically from Oracle background and not very well versed with DB2 much. I tried creating a stored procedure but not sure how can I loop through each row,

select TABSCHEMA, TABNAME from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'

Can someone please help ?



thanks a lot in advance







-----End Original Message-----