View previous topic :: View next topic
|
Author |
Message |
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
PLease help me on the following queries related to Imagecopy of Partitioned tablespace.
1. How to identify the details of Partitioned tablespace like number partition in a particular tablespace.
2. how to make a image copy of Partitioned tablespace in a way such that DIFFERENT PARTITION are stored IN DIFFERENT DDS.
I tried the following:
sysin dd *
copy tablespace databasename.tablespacename
copy DDN (DD01,DD02)
THIS IS MAKING SAME COPY IN BOTH THE DD'S
Looking for some solutions or helpful links.
Regards,
Sajjan. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Sajjan,
Quote: |
How to identify the details of Partitioned tablespace like number partition in a particular tablespace. |
Code: |
select dbname, tsname, partition from SYSIBM.SYSTABLEPART
where dbname like '%dbname%' and tsname like '%tsname%'; |
Quote: |
how to make a image copy of Partitioned tablespace in a way such that DIFFERENT PARTITION are stored IN DIFFERENT DDS |
Not Tested! Try and let us know if you get any errors......
Code: |
LISTDEF XTSPARTs INCLUDE TABLESPACE X PARTLEVEL
TEMPLATE TMP1 UNIT SYSDA
DSN (HLQ.&DB..&TS..&PART.)
DISP (MOD,CATLG,CATLG)
COPY LIST XTSPARTs COPYDDN (TMP1) PARALLEL (2) SHRLEVEL REFERENCE
|
Thank You,
Sushanth |
|
Back to top |
|
|
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
Thanks.
I have executed query :
SELECT DBNAME, TSNAME, PARTITION FROM SYSIBM.SYSTABLEPART
WHERE DBNAME LIKE '%RDBDB006%' AND TSNAME LIKE '%RDBSIJTS%'
I got 16 partition for tablespace DBSIJTS.
Then i have tried above code to copy each partition in different dataset. I have put 16 in place of X.
I m getting error "INVALID OPERAND '16' FOR KEYWORD 'LISTDEF' ".
After removing 16, it gives error
DSNU1038I DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TMP1
DDNAME=SYS00001
DSN=RDBD.PEXTB.N.PRICING.IMAGECPY.FILE
DSNU1038I DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TMP1
DDNAME=SYS00002
DSN=RDBD.PEXTB.N.PRICING.IMAGECPY.FILE
DSNU091I DSNUBBID - DDNAME 'SYS00001' IS A DUPLICATE |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Sajjan,
Thanks for testing.
I think, I should have used more xxxxx's.
Code: |
LISTDEF XTSPARTs INCLUDE TABLESPACE database.tablespacename PARTLEVEL
TEMPLATE TMP1 UNIT SYSDA
DSN (hlq.&DB..&TS..P&PART.)
DISP (MOD,CATLG,CATLG)
COPY LIST XTSPARTs COPYDDN (TMP1) PARALLEL (2) SHRLEVEL REFERENCE
|
Try now.
You should checkout, utility reference & guide for info.
Thanks,
Sushanth |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Use DSNUM option to get the image copy of partitions; probably using individual jobs for each partition. |
|
Back to top |
|
|
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
Thanks
I got RC 0.
I was missing PARTLEVEL PARTLEVEL-NUMBER[/img][/quote] |
|
Back to top |
|
|
|