Topic
  • 4 replies
  • Latest Post - ‏2013-04-26T15:12:55Z by samlowry63
samlowry63
samlowry63
6 Posts

Pinned topic Online REORG, PARTLEVEL and TEMPLATE for inline COPY... strange behavior!!!

‏2012-10-29T16:16:25Z |
Hi,

I found a strange behaviour of online REORG with inline COPY and a TEMPLATE parameter for copy dataset in z/OS DB2 V910 NFM.

When a partitioned tablespace is detected all partitions are put on the same inline copy dataset. Generally the smallest partition number!

About non partionned tablespace sysout it's like below;

PROCESSING LIST ITEM: TABLESPACE ZRX001FR.SRXWS0FR
TEMPLATE FULLCOPY DSN=TFRZBU0.DFQP.ZRX001FR.SRXWS0FR.A000(+1)
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SFACCTFR
TEMPLATE FULLCOPY DSN=TFRZBU0.DFQP.ZDB2PMFR.SFACCTFR.A000(+1)

But about partionned it's like below;

PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 19
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 17
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 10
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 9
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 26
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 25
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 23
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 22
PROCESSING LIST ITEM: TABLESPACE ZDB2PMFR.SPROGRFR PARTITION 20
TEMPLATE FULLCOPY DSN=TFRZBU0.DFQP.ZDB2PMFR.SPROGRFR.A000(+1)
UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

All partitions were stacked in the same copy dataset!!!

What we must do to obtain one inline copy dataset for each partition?

Thanks in advance.
Updated on 2013-01-09T10:30:23Z at 2013-01-09T10:30:23Z by samlowry63
  • samlowry63
    samlowry63
    6 Posts

    Re: Online REORG, PARTLEVEL and TEMPLATE for inline COPY... strange behavior!!!

    ‏2012-10-31T16:12:05Z  
    Hi,

    REORG with a LISTDEF select partitions of the same tablespace to optimize utility. Image Copy is made on the first part found! Strange but normal.

    A new parameter was added in REORG: PARALLEL YES|NO. In order to desactive parallel process. I do not know if my partition Image Copy will not be put on the same dataset but it is a clue.

    You must install a PTF (UK64590) to get the new REORG parameter;

    https://www-304.ibm.com/support/docview.wss?uid=swg1PM37293

    Hope this can help u.
  • SystemAdmin
    SystemAdmin
    3105 Posts

    Re: Online REORG, PARTLEVEL and TEMPLATE for inline COPY... strange behavior!!!

    ‏2013-01-05T08:48:50Z  
    can you post here your listdef and template commands?
    do you have the partition number in the template?
  • samlowry63
    samlowry63
    6 Posts

    Re: Online REORG, PARTLEVEL and TEMPLATE for inline COPY... strange behavior!!!

    ‏2013-01-09T10:30:23Z  
    can you post here your listdef and template commands?
    do you have the partition number in the template?
    Hi,

    Sysin file is below:

    TEMPLATE FULLCOPY
    DSN '&SSID(3,1).&DB(7).&DB(1,1).BCK.TEST.&DB..&TS..A&PART(3).(+1)'
    GDGLIMIT(15)
    DISP(NEW,CATLG,CATLG) UNIT SYSDA

    LISTDEF REORGALL
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0004
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0003
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0002
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0001
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0012
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0011
    INCLUDE TABLESPACE ZDB2PMFR.SPROGRFR PARTLEVEL 0010

    REORG TABLESPACE LIST REORGALL
    COPYDDN FULLCOPY
    DEADLINE 2013-01-09-18.00.00.000000
    FASTSWITCH YES
    LOG NO
    MAPPINGTABLE ZZZZ.MAPTAB01
    SHRLEVEL CHANGE
    SORTKEYS
    SORTDEVT SYSDA SORTNUM 4
    STATISTICS TABLE(ALL) INDEX(ALL)

    I found in page 508 in DB2 Version 9.1 for z/OS "Utility Guide and Reference" this sentence;

    "If you take an inline image copy of a range of partitions, DB2 writes one
    SYSCOPY record with ICTYPE=F for each partition, and each record has the
    same data set name."

    Thanks for you help!
  • samlowry63
    samlowry63
    6 Posts

    Re: Online REORG, PARTLEVEL and TEMPLATE for inline COPY... strange behavior!!!

    ‏2013-04-26T15:12:55Z  

    Hi,

    PTF was apply and PARALLEL NO parameter works fine!

    Now, each reorganized partition is in own Image Copy dataset.

    I hope this can help you... one day!

    Sam

    P.S. PARALLEL REORG parameter is definitively included in DB2 V10

     

     

     

     

    Updated on 2013-04-26T15:15:28Z at 2013-04-26T15:15:28Z by samlowry63