SELECT substr (rtrim (tabschema) || '.' || rtrim (tabname), 1, 50) TABLE_NAME,
       substr (const_checked, 1, 1) FK_CHECKED,
       substr (const_checked, 2, 1) CC_CHECKED,
       CASE status
          WHEN 'N' THEN 'NORMAL'
          WHEN 'C' THEN 'CHECK PENDING'
          WHEN 'X' THEN 'INOPERATIVE'
       END
          STATUS
  FROM syscat.tables
 WHERE tabschema = 'FCTMDT9'
  WITH UR;

SELECT TABSCHEMA,
       TABNAME,
       REORG_PENDING,
       INPLACE_REORG_STATUS,
       LOAD_STATUS,
       READ_ACCESS_ONLY,
       NO_LOAD_RESTART,
       NUM_REORG_REC_ALTERS,
       INDEXES_REQUIRE_REBUILD
  FROM TABLE (SYSPROC.ADMIN_GET_TAB_INFO_V97 ('FCTMDT9', '')) AS T
  WITH UR;

对于处在set integrity pending state的表，如何使之处于normal状态
WITH GEN (tabname, seq)
     AS (SELECT RTRIM (TABSCHEMA) || '.' || RTRIM (TABNAME) AS TABNAME,
                ROW_NUMBER () OVER (PARTITION BY STATUS) AS seq
           FROM SYSCAT.TABLES
          WHERE STATUS = 'C'),
     r (a, seq1)
     AS (SELECT CAST (TABNAME AS VARCHAR (128)), SEQ
           FROM gen
          WHERE seq = 1
         UNION ALL
         SELECT CAST (r.a || ',' || RTRIM (gen.tabname) AS VARCHAR (128)),
                gen.seq
           FROM gen, r
          WHERE (r.seq1 + 1) = gen.seq),
     r1 AS (SELECT a, seq1 FROM r)
SELECT 'SET INTEGRITY FOR ' || a || ' IMMEDIATE CHECKED;'
  FROM r1
 WHERE seq1 = (SELECT MAX (seq1) FROM r1)