(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?

Nikhil Bhole

(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?

Hi all,

We unloaded a Db2 table in a SYSREC dataset in which the DCB parameter was missed out. Hence, the dataset created was with RECFM ? (my guess is it would be RECFM=U). The unload ran successfully, however, we are not able to use this dataset for loading. What are the possible options to load data into the Db2 table using this dataset. I have already gone through the numerous threads on RECFM=U and I was not able to copy over the data to another dataset with RECFM=FB or VB by using IEBGENER, IDCAMS or FILEAID. We are running on Db2 zOS V10 NFM.

I am attaching a screenshot of the details of the SYSREC dataset format.

Looking forward to know the answer from all you experts here.

Regards,

Nikhil Bhole

Attachments

  • recfm error.jpg (137.3k)

Philip Sevetson

(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Nikhil Bhole)
**please note my email address change**
Nikhil,

How many rows does your Unload report having written? The Used Cylinders and Used Extents are both 0 on your screen-capture. In most cases, this would mean that nothing was written. (I’m not sure whether this is valid for RECFM=U.)

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Nikhil Bhole [mailto:[login to unmask email]
Sent: Tuesday, July 18, 2017 5:01 AM
To: [login to unmask email]
Subject: [DB2-L] - (Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?


Hi all,

We unloaded a Db2 table in a SYSREC dataset in which the DCB parameter was missed out. Hence, the dataset created was with RECFM ? (my guess is it would be RECFM=U). The unload ran successfully, however, we are not able to use this dataset for loading. What are the possible options to load data into the Db2 table using this dataset. I have already gone through the numerous threads on RECFM=U and I was not able to copy over the data to another dataset with RECFM=FB or VB by using IEBGENER, IDCAMS or FILEAID. We are running on Db2 zOS V10 NFM.

I am attaching a screenshot of the details of the SYSREC dataset format.

Looking forward to know the answer from all you experts here.

Regards,

Nikhil Bhole

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Nikhil Bhole

RE: (Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Philip Sevetson)

Hello Philip,

Thanks a lot for looking into this.

The NUMBER OF RECORDS UNLOADED=1995539.

Please let me know if the Unload JCL will help in any way so that I can provide it here.

Also, I'd like to mention that this tablespace that was created was an implicit tablespace.

Regards,

Nikhil Bhole

Philip Sevetson

(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Nikhil Bhole)
**please note my email address change**
Sorry, that’s all I had. I don’t know how to read a disk track which doesn’t have a RECFM. Anyone?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Nikhil Bhole [mailto:[login to unmask email]
Sent: Tuesday, July 18, 2017 9:50 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: (Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?


Hello Philip,

Thanks a lot for looking into this.

The NUMBER OF RECORDS UNLOADED=1995539.

Please let me know if the Unload JCL will help in any way so that I can provide it here.

Also, I'd like to mention that this tablespace that was created was an implicit tablespace.

Regards,

Nikhil Bhole

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Charles Brown

(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Nikhil Bhole)
Nikhil,
FYI-Your attachment wasn't found. Nonetheless, you've provided quite a bit info to help you resolve this issue. You stated "...we are not able to use this dataset for load.." what did you mean. What was the error msg. Lastly, what unload utility or proc did you use ? I'll wait for your answers. FYI - the receiving dataset should have inherited the DCB of the input dataset.
Hope this helps
Charles
NZ dba

Sent from my iPhone

> On Jul 18, 2017, at 4:00 AM, Nikhil Bhole <[login to unmask email]> wrote:
>
> Hi all,
>
> We unloaded a Db2 table in a SYSREC dataset in which the DCB parameter was missed out. Hence, the dataset created was with RECFM ? (my guess is it would be RECFM=U). The unload ran successfully, however, we are not able to use this dataset for loading. What are the possible options to load data into the Db2 table using this dataset. I have already gone through the numerous threads on RECFM=U and I was not able to copy over the data to another dataset with RECFM=FB or VB by using IEBGENER, IDCAMS or FILEAID. We are running on Db2 zOS V10 NFM.
>
> I am attaching a screenshot of the details of the SYSREC dataset format.
>
> Looking forward to know the answer from all you experts here.
>
> Regards,
>
> Nikhil Bhole
>
>
> Attachment Links: recfm error.jpg (141 k)
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> http://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Kal Sub

RE: (Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Nikhil Bhole)

Hi Nikhil,

Your unload JCL would be useful, as well as the job output if you have. You don't need to include DCB for Unload step. The dataset will get allocated with the right attributes automatically. So if your RECFM is 'U', it is likely the JCL hasn't done what you expected it to.

Regards

Kals


In Reply to Nikhil Bhole:

Hi all,

We unloaded a Db2 table in a SYSREC dataset in which the DCB parameter was missed out. Hence, the dataset created was with RECFM ? (my guess is it would be RECFM=U). The unload ran successfully, however, we are not able to use this dataset for loading. What are the possible options to load data into the Db2 table using this dataset. I have already gone through the numerous threads on RECFM=U and I was not able to copy over the data to another dataset with RECFM=FB or VB by using IEBGENER, IDCAMS or FILEAID. We are running on Db2 zOS V10 NFM.

I am attaching a screenshot of the details of the SYSREC dataset format.

Looking forward to know the answer from all you experts here.

Regards,

Nikhil Bhole