MVSFORUMS.com

deepeshk79 · Posted: Tue Apr 17, 2007 9:15 am Post subject: U0826 abend with HIDAM

Hi,

I was trying to run a program that does a load on a HIDAM database. Getting the below abend U0826

deepeshk79 · Posted: Tue Apr 17, 2007 9:18 am Post subject:

Also i can see that the error code is NI which means

Open error on work file data set during DB load with secondary indexes.
The status code is 'NI'.

But then not sure what went wrong with the secondary indexes.

kolusu · Posted: Tue Apr 17, 2007 9:53 am Post subject:

deepeshk79,

You are getting an OPEN error which means that you are missing DD statements. Did you add the DD names in the JCL for the indexes?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

deepeshk79 · Posted: Tue Apr 17, 2007 9:59 am Post subject:

Kolusu,

Yes i have added the DD names and the file does exist. The jcl is as below

deepeshk79 · Posted: Tue Apr 17, 2007 10:15 am Post subject:

Kolusu,

Is it possible for you to give me a sample KSDS and ESDS IDCAMS define for a (HIDAM,VSAM) type of definition. I'm not sure if the options given while defining the KSDS and ESDS are proper.

Thanks,
Deepesh

kolusu · Posted: Tue Apr 17, 2007 10:18 am Post subject:

deepeshk79 · Posted: Tue Apr 17, 2007 10:28 am Post subject:

Hi Kolusu,

Yes the reason was for the KSDS I had given RECSZ as (9 9), when i changed it to (10 10) it worked.

However I think this is not applicable for ESDS. When I changed the ESDS RECSZ to an even number, it gave me an open error for the ESDS.

Thanks for your help !!!

Deepesh

kolusu · Posted: Tue Apr 17, 2007 10:36 am Post subject:

deepeshk79 · Posted: Tue Apr 17, 2007 10:50 am Post subject:

Kolusu,

Yes I got the same error. May be the error was due to the diff of 7 not being maintained. I had changed the Rec size from 2041 to 2040. The CI Size was 2048.

Thanks,
Deepesh