Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DSN1copy - vsam put error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
bbessa

New User


Joined: 03 Aug 2006
Posts: 13
Location: Brazil

PostPosted: Tue Jan 22, 2008 1:09 am    Post subject: DSN1copy - vsam put error
Reply with quote

Hello guys,

I've running into a problem here at work while trying to copy 16 GB sized tablespace partitions using DSN1COPY. The target dataset can't pass the 2 GB size mark for some odd reason, when it reaches that mark, DSN1COPY stops with "VSAM PUT ERROR RPLERREG = 008, RPLERRCD = 028" message. Doing a search over the Internet, I've came across the IBM documentation that specifies the limits to DSN1COPY and it clearly says that the utility can't copy datasets over 4GB UNLESS the target dataset is EA-Enabled. Guess what, the target and source datasets are EA-Enabled and I'm still getting errors. I don't know what I am doing wrong here. We've enough volumes with contiguous free space to hold the target dataset, volume count in the SMS DATACLASS is set to 10, target dataset is EA-enabled and I've tried all sorts of values in the DSSIZE parameter of DSN1COPY. Am I missing something? Can anyone help?

Thanks!

Bernardo
Back to top
View user's profile Send private message

bbessa

New User


Joined: 03 Aug 2006
Posts: 13
Location: Brazil

PostPosted: Wed Jan 23, 2008 12:55 am    Post subject:
Reply with quote

OK. Here's the workaround: I've changed the tablespace's PRIQTY value to fit exactly one volume, not 1 and half as before.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 23, 2008 2:21 am    Post subject: Reply to: DSN1copy - vsam put error
Reply with quote

Hello bbessa and welcome to the forums,

Thank you for posting your resolution icon_smile.gif

d.sch.
Back to top
View user's profile Send private message
bbessa

New User


Joined: 03 Aug 2006
Posts: 13
Location: Brazil

PostPosted: Mon Jan 28, 2008 10:33 pm    Post subject:
Reply with quote

The posted workaround didn't work for much time. We had another failed copy on a index with another set of storage parameters. So I did a little more research and came up with the cause to dsn1copy problem. DB2v8 for z/OS has the zparm MGEXTSZ that, when set to YES, makes DB2 uses some kind of automated space management for your index and table spaces even if you manually define your SECQTY values. It's seems that DB2 was choosing odd values (can't verify this though) for SECQTY while the index was growing thus making dsn1copy fail. We've put the zparm back to it's default value, NO, re-created the index and everything worked flawless.

It's seems MGEXTSZ is not really a good parameter to use if you know your storage very well. Does anyone have good experiences with this zparm to share?
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 IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us