Search for "ALTER TABLE" in the Db2 12 for z/OS SQL Reference. This is the definitive reference for what ALTER operations are supported, which trigger pending states, and the exact syntax. Pay particular attention to the "Notes" section of each ALTER variant, which documents side effects.