Alter and ADD limitkyes sametime

bekir arslan

Alter and ADD limitkyes sametime

Hello all,

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,

Bekir ARSLAN.

Attachments

  • Limitkeys.txt (2k)

Roy Boxwell

Alter and ADD limitkyes sametime
(in response to bekir arslan)
Hi!



Well you only are forced if you still have the DISCARDDN and PUNCHDDN in the control cards. Was that the case?



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: bekir arslan [mailto:[login to unmask email]
Sent: Friday, November 9, 2018 11:51 AM
To: [login to unmask email]
Subject: [DB2-L] - Alter and ADD limitkyes sametime



Hello all,

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,

Bekir ARSLAN.



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

Attachments

  • smime.p7s (5.1k)

Tushar Jha

RE: Alter and ADD limitkyes sametime
(in response to bekir arslan)

I think that you are trying to alter the limitkeys of last partition of your table and that has put it in Reorg Pending.

Once the last part is in Reorg Pending, Reorg needs SYSDISC ( and SYSPUNCH ), so that it can write the discarded records from the last partition to the discard file.

Regarding the failure of Alter ADD Part , I  think that went down, since the table/last part  was already in Reorg pending and  unless you clear that, it is not allowed.I will have to test to be sure on this.

Thank you.

James Campbell

Alter and ADD limitkyes sametime
(in response to bekir arslan)
Have a read of
http://www-01.ibm.com/support/docview.wss?uid=swg1PI42999

I am sure it will give you an idea of how to proceed. Note that it uses MAXVALUE, not
something like 9999-12-31, as the limit key on the last partition.

James Campbell

On 9 Nov 2018 at 3:50, bekir arslan wrote:

>
> Hello all,
> 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,
> Bekir ARSLAN.
>

bekir arslan

RE: Alter and ADD limitkyes sametime
(in response to James Campbell)

Thanks for all your advice and feedback,

Have a nice week.

Bekir ARSLAN