Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Imagecopy of Partitioned tablespace.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Sat May 01, 2010 12:16 pm    Post subject: Imagecopy of Partitioned tablespace.
Reply with quote

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
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sun May 02, 2010 8:44 am    Post subject:
Reply with quote

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
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Wed May 26, 2010 4:44 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed May 26, 2010 6:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Wed May 26, 2010 6:28 pm    Post subject:
Reply with quote

Use DSNUM option to get the image copy of partitions; probably using individual jobs for each partition.
Back to top
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Wed May 26, 2010 6:35 pm    Post subject:
Reply with quote

Thanks

I got RC 0.

I was missing PARTLEVEL PARTLEVEL-NUMBER[/img][/quote]
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm
No new posts BMC UNLOAD for a LOB tablespace JyothsnaNayak DB2 2 Wed Jul 29, 2015 2:02 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us