IDMS

We're getting an 0770 error when trying to connect a record to an index that was part of an area re-size that was done last Tuesday.  I tried recompiling dialog but that didn't fix it. 

A 70 minor code indicates a problem opening the database file. It could be a page size mismatch - the DMCL page size does not match the file blocksize.

It seems the resize messed something up. Recompiling the dialog will not fix errors like this. 

I check page size and blksize   both match

any other possibilities?

I'm not really sure. Do the number of pages in the area match the number of records in the database file? Is the CV really using the the file you think it is using (do a DCMT D FILE segment.file to check)?

Are there any errors in the CV Job log?

Can you run a print space on the area?

Do you have hard coded database file dd cards in your jobs (or in your CV startup for that matter?) that is an opportunity for failure …..

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266

Chris,  the CV has all the database file hard coded in the started task

except for this new file.  Thought dynamic allocation would work for the new file

IASCHEMA.AR-EIEMPL-ADUSER         0     870,001     870,450   2,676  X3310001  
                                                                                                                    X331001X  

the above show what the DMCL has ....    the second line is the new file ddname

I ran a print space on the area and is shows :

    FILE   IASCHEMA.X3310001                                                           
    BLOCKS              1 THRU            225                                          
    PAGES         870,001 THRU        870,225                                          
                                                91-100%              2                 
                                                81-90 %              0                 
                                                71-80 %              0                 
                                                61-70 %              0                 
                                                51-60 %              0                 
                                                41-50 %              1                 
                                                31-40 %              1                 
                                                21-30 %             12                 
                                                11-20 %             83                 
                                                00-10 %            125                 
                                                SMPS                 1                 
                                                TOTAL              225                 
    FILE   IASCHEMA.X331001X                                                           
    BLOCKS              1 THRU            225             is this worng?   should it say 226 thru 450?                                  
    PAGES         870,226 THRU        870,450              

-------- Data File -------- Mode Stat Pg-Size  Fl-Type M-Cache S-Cache DD-Name                 
IASCHEMA.X331001X            Err 3005   2676  non-VSAM    No      No   X331001X                
  Pre-fetch: Not-Allowed (DMCL)                                   UNALLOCATED                  
  DSname: (DMCL).. IDOT.CV10.X331001X                             DISP=SHR                     
                                                                                               

it has an ERR 3005   ?

No, that isn't wrong. That is the block count within that file, not within the area. Does the print space complete successfully? You show no stats from the second file in the area.

It looks like you've extended the area by adding a second file to the area. Did you format the new file?

Can you browse  IDOT.CV10.X331001X and see the empty pages?

the print space jobs works fine.  I can browse the new file in 3.4 and see empty pages.

did you this error ?

it has an ERR 3005 - Execution of the specified DML function will violate a DUPLICATES NOT ALLOWED restriction

is that normal for index file?

    FILE   IASCHEMA.X331001X                                                          
    BLOCKS              1 THRU            225                                         
    PAGES         870,226 THRU        870,450                                         
                                                91-100%            225                
                                                81-90 %              0                
                                                71-80 %              0                
                                                61-70 %              0                
                                                51-60 %              0                
                                                41-50 %              0                
                                                31-40 %              0                
                                                21-30 %              0                
                                                11-20 %              0                
                                                00-10 %              0                
                                       AVAILABLE Space Distribution Report            
                                                 AVAIL         NUMBER                 
                                                 SPACE        OF PAGES                
    FILE   IASCHEMA.X331001X                                                          
                                                SMPS                 0                
                                                TOTAL              225                
Total Space Allocated                                1,204,200                        
Total Space Available  (Percent)                       656,648     (54.52%)           
Total Space Used                                       547,552                        

Chris,  The CV has hard code dd names and files.  I didn't add this new file to CV started task

Well then …..

Unless the dmcl specifies the dataset names,  you MUST specify ALL database dataset names in the startup JCL

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266

Chris,  here is what is shown when I a LOOK DMCL

IASCHEMA.X331001X           X331001X BDAM   No    No  DEFAULT_BUFFER                
      DSname: (DMCL)   IDOT.CV10.X331001X                                           

You may want to open a case for this. I searched all of our internal tracking systems and could not find a single occurrence of a 0770 report. 

John,

I WOULD like to but this customer is running V17 that's not supported and they don't have extended support

The 3005 error is the error opening the file. It is not database error code. 

I think your CV hasn't allocated the file. It is not getting opened. Is the file name IDOT.CV10.X331001X correct? Can you see in your CV job that the file got allocated?

It might be that the file didn't exist when you did the DMCL NC and the CV has flagged the file as unallocated.

Try running these commands:

DCMT V FI IASCHEMA.X331001X CLOSE

DCMT V FI IASCHEMA.X331001X ALLOCATE

DCMT V FI IASCHEMA.X331001X OPEN

Then issue the DCMT D FI IASCHEMA.X331001X again.

3005 Error Opening File IASCHEMA.X331001X

Issue the DCMT D FI IASCHEMA.X331001X again and show the full output.

How did you implement this? With a DMCL new copy? Has the CV been cycled since you made this change?

If the DMCL had no files dynamically allocated when it came up, I think dynamic allocation is not enabled. You may need to cycle the Cycle the CV to enable it.

-------- Data File -------- Mode Stat Pg-Size  Fl-Type M-Cache S-Cache DD-Name         
IASCHEMA.X331001X            Err 3005   2676  non-VSAM    No      No   X331001X        
  Pre-fetch: Not-Allowed (DMCL)                                   UNALLOCATED          
  DSname: (DMCL).. IDOT.CV10.X331001X                             DISP=SHR             
                                                                                       

This was implanted a week ago and the CV is cycle nightly. 

The file shows as unallocated. Are there any messages in the CV job log for the file?

As long as IDOT.CV10.X331001X is correct file name, I'm out of ideas. 

I don't see any errors in the log pertaining to the file.  Thanks for the help.  I opened a ticket with CA support.  Hope they help out.  Thanks again for the help