79777359

Date: 2025-09-28 13:49:47
Score: 1
Natty:
Report link

I think the answer is to run the query this way:

SELECT TABNAME FROM SYSIBMADM.ADMINTABINFO WHERE TABSCHEMA = 'LIBRAT' AND REORG_PENDING <> 'N';

Because the value of that column can be either 'Y' (for reorg pending) or 'C' (for check pending)--both of which are an operation pending (state=57007).

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Dave Clark