|
View previous topic :: View next topic
|
| Author |
Message |
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
Hello!
I created an ISAM a few days ago and it has been brought to my notice today that guys are not able to access it. What I did was a REPRO copying a flat file into the ISAM. Before copying data, I did a delete-define of the ISAM. During delete/define, I used the MODEL dataset from production (which is defined correct).
I did not check then, but now no one is able to get in this ISAM. The irony is that I do not have the backups to restore the file again. The funny thing is that I am not able to delete this dataset too. If anyone can help me out why this might be happening, IT WOULD BE REALLY REALLY GREAT!!!!
Listcat:
| Code: |
DS= XX.X.XXXXXX.XXXX.XX
IAM FILE ANALYSIS - DSN=XX.X.XXXXXX.XXXX.XX
------------------------------------------------------------------------------
FILE FORMAT -- = ENHANCED - FILE STATUS ----------- = LOADED
RECORD SIZE -- = 2044 - AVG RECORD SIZE ------- = 64
CI SIZE ------ = 4096 - FREESPACE - CI% - CA% - = 20 20
BLOCK SIZE --- = 13682 - EXTENDED OVERFLOW ----- = 9273772 RECS
BLOCK FACTOR - = 4 - REQUESTED OVERFLOW ---- = 0 RECS
VAR OVERFLOW - = YES - EXTENDED OVERFLOW ----- = 50515 BLOCKS
KEY SIZE ----- = 64 - EXTENDED OVERFLOW USED = 94 %
KEY OFFSET --- = 0 - EXTENDED PE ----------- = 0 BLOCKS
FILE TYPE ---- = KSDS - EXTENDED ALLOCATED ---- = 54038 BLOCKS
DEVICE TYPE -- = 3390 - EXTENDED AVAILABLE ---- = 3242 BLOCKS
VOLUME COUNT - = 15 - SPACE USED ------------ = 114060 TRACKS
VOLSER ------- = GTC026 - SPACE ALLOCATED ------- = 24000 TRACKS
VOLSER ------- = GTC207 - SPACE ALLOCATED ------- = 24000 TRACKS
VOLSER ------- = GTC043 - SPACE ALLOCATED ------- = 24000 TRACKS
VOLSER ------- = GTC034 - SPACE ALLOCATED ------- = 24000 TRACKS
VOLSER ------- = GTC051 - SPACE ALLOCATED ------- = 18870 TRACKS
TOTAL EXTENTS = 77 - TOTAL SPACE ALLOCATED - = 114870 TRACKS
PRIMARY SPACE = 100 - SECONDARY SPACE ------- = 100 CYL
MULTIVOLUME -- = PRIMARY - MAX SECONDARY --------- = 100 CYL
RELEASE ------ = NO - SHARE OPTIONS --------- = 2
DATA COMPRESS = SOFTWARE - INDEX COMPRESS -------- = YES
TOTAL RECORDS = 57320865 - INSERTS --------------- = 184
UPDATES ------ = 3 - DELETES --------------- = 44
HIGH USED RBA = 6095946 - HIGH ALLOCATED RBA ---- = 6139264 KB
FILE DEFINED - = 2012.111 - 04/20/2012 - 12:45 PM - = 12:45:41
FILE LOADED -- = 2012.111 - 04/20/2012 - 12:50 PM - = 12:50:20
LAST UPDATED - = 2012.236 - 08/23/2012 - 1:19 AM - = 01:19:01
STORAGE REQUIRED FOR COMPRESSED PRIME INDEX -- = 8656768
NUMBER OF IAM DATA BLOCKS -------------------- = 402902
EXTENDED HIGH ALLOCATED RBN ------------------ = 459479
FILE REORGANIZATION IS RECOMMENDED
------------------------------------------------------------------------------
IAM499 IAMLISTC(9.0/04P ) PROCESSING COMPLETED |
Ran IDCAMS REPRO to take a backup of the file but it failed:
| Code: |
IDCAMS SYSTEM SERVICES TIME: 02:09:51
REPRO INFILE(VSAM) OUTFILE(TAPE)
IDC2908I VSAM NOT FOUND IN SYSTEM
IDC3300I ERROR OPENING VSAM
IDC3304I ** JCL STATEMENT MISSING
IDC0005I NUMBER OF RECORDS PROCESSED WAS 0
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12 |
Ran SORT to take backup, it failed:
| Code: |
SYNCSORT FOR Z/OS 1.4.0.1R U.S. PATENTS: 4210961, 5117495 (C) 2010 SYNCSO
XXXXXX z/OS 1.11.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 94DD0, MODEL 2094 703 LICEN
SYSIN :
SORT FIELDS=COPY 0000000
WER276B SYSDIAG= 232158, 990499, 990499, 1634100
WER164B 6,884K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 992K BYTES USED
WER146B 32K BYTES OF EMERGENCY SPACE ALLOCATED
WER254A SORTIN VSAM OPEN ERROR -- 88
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
Tried to open the ISAM thru FileManager, it failed:
| Code: |
File Manager View Entry Panel
Command ===>
Input Partitioned, Sequential or VSAM Data Set, or HFS file:
Data set/path name 'XX.X.XXXXXX.XXXX.XX' +
Member . . . . . . (Blank or pattern for member list)
Volume serial . . (If not cataloged)
Start position . . +
Record limit . . . Record sampling
Copybook or Template:
Data set name . .
Member . . . . . . (Blank or pattern for member list)
Processing Options:
Copybook/template Start position type Enter "/" to select option
3 1. Above 3 1. Key Edit template Type (1,2,S)
2. Previous 2. RBA Include only selected records
3. None EssssssssssssssssssssssssssssssssssssssssN eclen 80
4. Create dy e Insufficient virtual storage available e
DssssssssssssssssssssssssssssssssssssssssM
|
|
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| what about getting Your support involved ? |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
Yes. Thats an option. But that would take a long time since we do not have direct access to the support guys. I am pretty much sure that you guys have more expertise than our support guys  . So thought of asking it in forum first. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| Yes. Thats an option. But that would take a long time since we do not have direct access to the support guys. I am pretty much sure that you guys have more expertise than our support guys . So thought of asking it in forum first. |
stupid reason ( considering also that You qualify Yourself as Senior SE ) ,
why do You think that we should do the work for which You/Your support are getting paid.
a forum is not the remedy for a poor organization
| Code: |
FILE DEFINED - = 2012.111 - 04/20/2012 - 12:45 PM - = 12:45:41
FILE LOADED -- = 2012.111 - 04/20/2012 - 12:50 PM - = 12:50:20
LAST UPDATED - = 2012.236 - 08/23/2012 - 1:19 AM - = 01:19:01 |
anyway the description of the problem is a bit murky ...
the dataset was created and loaded four months ago...
meditate what happened since then. |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
| no one accessed it. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
According to the output you show, you didn't do a delete/define, which is what enrico is pointing out to you.
It was defined and loaded on day 111 of this year, 20 April. |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
Yes. Thats correct. It was loaded a few months back. While loading that time, I did a delete/define.
But the thing is, I am not able to access it (read/write/delete) using IDCAMS/SORT/FileManager. Even putting DELETE in front of the dataset is not deleting it.
Delete (ISPF 3.4) in front of the dataset gives
| Code: |
IEC142I 113-38,IFG0194D,XXXXXX,$$TSL000,ISP05354,3233,GTC026,XX.X.XXXXXX.XXXX.XX
*** |
Tried DELETE thru IDCAMS but it gave 'IDC3300I ERROR OPENING VSAM' |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
I see multiple errors here.
For the IDCAMS REPRO, you've this error:
| Quote: |
| IDC3304I ** JCL STATEMENT MISSING |
which means:
| Quote: |
| Explanation: The DD statement named in a FILE, INFILE, or OUTFILE parameter cannot be found. If the job or Time Sharing Option/Extensions (TSO/E) session contains a delete request that causes the system to invoke dynamic deallocation, the DD statement for the deleted data set is not accessible for the remainder of the job or session. |
- so check that if there is any typo error in your Job.
For the SORT, you've this:
| Quote: |
| WER254A SORTIN VSAM OPEN ERROR -- 88 |
For this I'll hazard a guess and ask, what is the region size? You know that, depending on site customization, CLASS may impose a limit on REGION. Try coding a larger REGION size and try again.
What SORT-statements did you use? |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
Nice one Anuj. I could take a backup with REGION=0 and also able to DELETE/DEFINE now.
THANK YOU. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Glad, you got it working.
Suggest, if you intend to do this in PROD, please dont' use REGION=0. A higher value should be good enough, usually. Coding a zero REGION size sets the limits to all of the 24-bit and 31-bit virtual storage available to the address space. Usually, for 24-bit storage, defaults are between 8M-10M and between 1600M-1900M for 31-bit storage. So even if you code that, it will not be honored and may be further limited by an IEALIMIT or IEFUSI exit. |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
| Ok. Point noted. Thank you again Sir!! |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
You're welcome and Good Luck!  |
|
| Back to top |
|
|
|
|
