I'm using db2 v11 Z/OS and my question is I'm tryin to alter one of my tables limitkey which is from '9999-12-30' to '2018-01-31' (this part has 5 million datas) and also add some more partition such as '2018-02-28','2018-03-31','2018-04-3' etc. when I sent alter and add at same job, alter clause execute and then want to reorganise and add clausess are not execute,so job finisshed rc =8.
Then I create a reorganize job for table, but this time reo finished with rc= 8 and at the output error definition Shows that
DSNURORG - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSDISC
DSNURORG - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSPUNCH.
My question is shall I alter limit keys (partition has datas) without using sysdic and syspunch.
Thanks for your answers,