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
 

 

DB2 VSAM LDS cisize

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

New User


Joined: 08 Apr 2009
Posts: 3
Location: Lisboa

PostPosted: Thu Apr 09, 2009 3:10 pm    Post subject: DB2 VSAM LDS cisize
Reply with quote

Hello!
In my company we have DB2 for zOS version 8 installed.
As you might know, during version 8 migration process some Catalog Tablespaces where converted in VSAM LDS with cisize other than 4k, , ie, t some of them where converted to LDS 8k, 32k etc...

My question is: is there any other process to convert a user-defined Tablespace DB2's catalog from 4k cisize to 8k cisize ?
Putting in other words: supposing we find a Tablespace Catalog with LDS cisize of 4k, when it should be with 8k size, how can we convert it now?

Any help will be much appreciate !
Thanks
Back to top
View user's profile Send private message

wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Apr 11, 2009 3:05 am    Post subject:
Reply with quote

If that z-parm which allows ci size more than 4K is on and you have a tablespace in a bufferpool more than 4K, all you have to is reorg the tablespace and it should convert it to CI size larger than 4K.

Not sure how this works if you have a user defined dataset instead of DB2 defined. If the above doesn't work, there is an option in Define CLuster called CONTROLINTERVALSIZE. Can try that and test it.

Not sure what you mean by 'Tablespace Catalog'.
Back to top
View user's profile Send private message
Xico Fino

New User


Joined: 08 Apr 2009
Posts: 3
Location: Lisboa

PostPosted: Mon May 11, 2009 10:19 pm    Post subject: Reply to: DB2 VSAM LDS cisize
Reply with quote

Thank you for your help !

'Tablespace Catalog': I want to mean that is a DSNDB06 tablespace.

I made a new allocation using Define Cluster with CISIZE 8K, and then I tried to make a REPRO from de old file (4K) to the new one (8K).

The issue is that it returns a the following error msg:

REPRO INFILE(I) OUTFILE(O)
IDC3302I ACTION ERROR ON ...dsn file ...
IDC3351I ** VSAM I/O RETURN CODE IS 108 - RPLFDBWD = X'8508006C'

IDC0005I NUMBER OF RECORDS PROCESSED WAS 0

which means:
For a Logical I/O Error
108 The RECLEN specified was larger than the maximum allowed,
equal to 0, or smaller than the sum of the length and the
displacement of the key field of the base cluster or
related alternate index (AIX). The RECLEN was not equal to
the slot size specified for a relative record data set.

But I didn't specify any Record Length!!! (it´s a Linear Dataset), so I suppose REPRO won't be a good solution for that 'conversion'.

Does anyone have more ideas? Thanks in advance!
icon_biggrin.gif
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: Tue May 12, 2009 5:14 am    Post subject:
Reply with quote

Hello,

Suggest you use only db2 utilities to work with db2 components. . .

Even if you get around the system now, something may fail at a later time and you will have a nightmare.

fwiw. . .

Have you opened an issue with db2 support?
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Tue May 12, 2009 10:55 pm    Post subject:
Reply with quote

Since they are catalog datasets I guess they have to be user defined. I don't have experience in DB2 installation etc but I doubt REPRO is a good option here.

Reorg will be a better one. But trying to change CI size on catalog objects may not be a good idea. I wonder why you want to do that.

In our case, the z-parm change-reorg fix was suggested by IBM and I think they implicitly meant it to be valid for application object datasets, not catalog. Because I see our catalog datasets, some have CIsize 8k.

So contact IBM. But please tell us why you want to reduce Cisize.

Thanks!
Back to top
View user's profile Send private message
Xico Fino

New User


Joined: 08 Apr 2009
Posts: 3
Location: Lisboa

PostPosted: Tue May 19, 2009 9:08 pm    Post subject: Reply to: DB2 VSAM LDS cisize
Reply with quote

Hello,

First off all, I want to apologize for not giving any notice so far, but I’ve been very busy.

Regarding my issue:

1 - You all must be right: REPRO is not, in fact, a good ideia.

2 – As you suggest I’ll try to solve this issue with DB2 utilities, like REORG.

3 – I intend to do the follow ‘experience’ in a lab environment :

a) Run a REORG (SHRLEVEL REFERENCE) with UNLOAD PAUSE of that Tablespace.
b) When REORG finishes the UNLOAD phase, I’ll rename the old dataset (with CI 4K) and I'll make a new allocation with the proper name but with CI 8K.
c) Then, I’ll make a restart on REORG, and I suppose it will LOAD to this new dataset (8K) without problems. So I expect!

When I try it, I ‘ll give you feedback.

Thanks for your help !
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: Tue May 19, 2009 11:42 pm    Post subject: Reply to: DB2 VSAM LDS cisize
Reply with quote

You're welcome - thanks for the update icon_smile.gif

Good luck,

d
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 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 VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm


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