|
View previous topic :: View next topic
|
| Author |
Message |
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
Hi,
We were using these control parameters to delete/define the VSAM cluster
| Code: |
DELETE -
HLQ.some.vsam -
CLUSTER PURGE
IF MAXCC < 9 THEN SET MAXCC = 0
DEFINE CLUSTER -
(NAME(HLQ.some.vsam ) -
DATACLASS (EXT4GIGY) -
VOLUMES(* * * * *) -
.
.
. |
they asked me to include
| Code: |
| LISTC ENT('HLQ.some.vsam ') ALL |
and I did like this
| Code: |
LISTC ENT('HLQ.some.vsam') ALL
DELETE -
HLQ.some.vsam -
CLUSTER PURGE
IF MAXCC < 9 THEN SET MAXCC = 0
DEFINE CLUSTER -
(NAME(HLQ.some.vsam ) -
DATACLASS (EXT4GIGY) -
VOLUMES(* * * * *) -
.
.
. |
and it gave me MAXCC=12, unfortunately job is gettign flushed from spool also - so I could not check the sysprint, also I looked in VSAM Demystified but I'm not sure what to look for there, can you please assit me knowing the correct way of using LISTC along with DELETE? |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
A pity you dont show all the control cards.
I see a continuation after volumes, so where is the
rest of the input?
If a delete failes there is a 100% change the dataset is not
existing (anymore), so you can do a : SET MAXCC = 0 without
testing MAXCC. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
I've just executed a LISTCAT, followed by a DELETE followed by a DEFINE with no problems
| Code: |
LISTCAT ENT('My VSAM dataset') ALL
DELETE 'My VSAM dataset'
SET MAXCC EQ 0
DEFINE CLUSTER ( -
NAME('My VSAM dataset ') -
VOL(* *) -
remainder of define stements
|
I did notice that your commands start in column 1 - is this for real ? |
|
| Back to top |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
Thanks for the response Peter. They were jus the other DEFINE parameter, so I thought to avoid posting them. Here are they:
| Code: |
DELETE -
HLQ.some.vsam -
CLUSTER PURGE
IF MAXCC < 9 THEN SET MAXCC = 0
DEFINE CLUSTER -
(NAME(HLQ.some.vsam) -
DATACLASS (EXT4GIGY) -
VOLUMES(* * * * *) -
KEYS(27,0) -
FREESPACE(10,10) -
SHR(2,3) -
CYLINDERS(&CYL1.,&CYL2.) -
RECORDSIZE(75,75) -
REUSE SPEED) |
I need to include this
| Code: |
| LISTC ENT([color=red][b]'[/b][/color]HLQ.some.vsam ') ALL |
in the above.
I believe I got it working, I was missing the starting-inverted-comma in "LISTC ENT('HLQ.some.vsam ') ALL ", I used it like "LISTC ENT(HLQ.some.vsam ') ALL " - however, I'd like to know if I used it correctly.
ON one more thing I need suggestion, if I need to know the LISTCAT of 'HLQ.some.vsam' before delete/define then it should be executing LISTCAT first and then delete/define or loaction of LISTCAT command in above existing card is of no concern, please susggest. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Im missing a ) after the REUSE SPEED).
Thats why i wanted to see the rest of the input.
Beside that i never used ' for a listcat entry command, worked
like a charm for me. |
|
| Back to top |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
Peter, I believe parenthesis are complete:
| Quote: |
DELETE -
HLQ.some.vsam -
CLUSTER PURGE
IF MAXCC < 9 THEN SET MAXCC = 0
DEFINE CLUSTER -
(NAME(HLQ.some.vsam) -
DATACLASS (EXT4GIGY) -
VOLUMES(* * * * *) -
KEYS(27,0) -
FREESPACE(10,10) -
SHR(2,3) -
CYLINDERS(&CYL1.,&CYL2.) -
RECORDSIZE(75,75) -
REUSE SPEED) |
are not they? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
You start with (NAME(HLQ.some.vsam), so thats 2 left ((.
Means there has to be somewhere an ending )).
That will be your last parameters : REUSE SPEED)) |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Oops,
im so sorry. Im totally wrong here. A kind of tunnel vision or Friday happy hour time.
Excuse me. |
|
| Back to top |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
Thanks expat, it looks like I missed your reply.
I'm little unsure about the preference of command execution - is it "FIFO", if instead of what you've posted I use:
| Code: |
DELETE 'My VSAM dataset'
SET MAXCC EQ 0
DEFINE CLUSTER ( -
NAME('My VSAM dataset ') -
VOL(* *) -
remainder of define stements
LISTCAT ENT('My VSAM dataset') ALL |
LISTCAT at last - will this give the LISTC statistics of newwly defined vsam? I'm trying it out but I'm not very good in reading LISTC output yet. |
|
| Back to top |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
It's ok Peter... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hi Peter,
| Quote: |
| A kind of tunnel vision or Friday happy hour time. |
Must be nice. . . It is still 2 hours 'til lunch here. . . 
d |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| dick scherrer wrote: |
Hi Peter,
| Quote: |
| A kind of tunnel vision or Friday happy hour time. |
Must be nice. . . It is still 2 hours 'til lunch here. . .
d |
Yes Dick,
but we dutchies start always early. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| PeterHolland wrote: |
Yes Dick,
but we dutchies start always early. |
In fact sometimes they even start so early it's before they've finished yesterday  |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Well expat, sometimes we try to be belgians. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| but we dutchies start always early. |
| Quote: |
| Well expat, sometimes we try to be belgians. |
There's a difference?!?!?!
 |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Robert Sample wrote: |
| Quote: |
| but we dutchies start always early. |
| Quote: |
| Well expat, sometimes we try to be belgians. |
There's a difference?!?!?!
|
Robert,
only in the zillion brands of beer and the chocolate the belgians have.
|
|
| Back to top |
|
|
|
|
