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
 

 

Not able to Access $IAM dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 1:08 pm    Post subject: Not able to Access $IAM dataset
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Aug 23, 2012 1:18 pm    Post subject: Reply to: Not able to Access $IAM dataset
Reply with quote

what about getting Your support involved ?
Back to top
View user's profile Send private message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 1:21 pm    Post subject:
Reply with 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 icon_wink.gif . So thought of asking it in forum first.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Aug 23, 2012 1:24 pm    Post subject: Reply to: Not able to Access $IAM dataset
Reply with quote

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
View user's profile Send private message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 1:55 pm    Post subject:
Reply with quote

no one accessed it.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Thu Aug 23, 2012 2:48 pm    Post subject: Reply to: Not able to Access $IAM dataset
Reply with quote

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
View user's profile Send private message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 3:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 23, 2012 3:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 3:47 pm    Post subject:
Reply with quote

Nice one Anuj. I could take a backup with REGION=0 and also able to DELETE/DEFINE now.

THANK YOU.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 23, 2012 6:49 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Biswajit D

New User


Joined: 17 Apr 2012
Posts: 50
Location: India

PostPosted: Thu Aug 23, 2012 6:51 pm    Post subject:
Reply with quote

Ok. Point noted. Thank you again Sir!!
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 23, 2012 7:03 pm    Post subject:
Reply with quote

You're welcome and Good Luck! icon_smile.gif
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am


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