Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Rename vsam tablespace dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1025
Location: Bangalore,India
PostPosted: Mon Sep 22, 2008 10:55 am    Post subject: Rename vsam tablespace dataset
 Reply with quote
Hello All,

Would you kindly tell me how to rename VSAM DATA SET of db2 tablespace? Actually cluster name is same buts somebody renamed data dataset & now it does not have any catalog entry. I tried using IDcams but
not successful

Tablespace name :TSPRPA83
Database name :BCQTPP13

Tablespace vsam data set
Code:

DSNE.DSNDBC.BCQTPP13.TSPRPA83.I0001.A001                *Vsam*
DSNE.DSNDBD.BCQTPP13.A0010042.D7215335 


Somebody renamed it from DSNE.DSNDBC.BCQTPP13.TSPRPA83.I0001.A001 to DSNE.DSNDBD.BCQTPP13.A0010042.D7215335

Please let me know how we can rename it again
Back to top
View user's profile Send private message
References
Anuj D.

Global Moderator


Joined: 22 Apr 2006
Posts: 2222
Location: Phoenix, AZ
PostPosted: Mon Sep 22, 2008 11:00 am    Post subject:
Reply with quote
Hi,

You might like to check this link..

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0003492.htm
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 288
PostPosted: Mon Sep 22, 2008 11:34 am    Post subject: Reply to: Rename vsam tablespace dataset
 Reply with quote
Are you Sure DSNE.DSNDBD.BCQTPP13.A0010042.D7215335 is a renamed VSAM dataset.

Is it not the Data component of the table BCQTPP13 which has been migrated to tape

Generally DSNDBD is the dataportion and the DSNDBC is the clustering portion
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1025
Location: Bangalore,India
PostPosted: Mon Sep 22, 2008 12:32 pm    Post subject:
Reply with quote
Yes prashanth its data portion of the table but its nt migrated its still on dasd but somebody renamed it
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1