(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

Wayne Stevens

(Db2 zOS V10 NFM) Unable to load a Db2 SYSREC dataset with Record Format.....: ?
(in response to Nikhil Bhole)
Did you run the job more than once? Is the sysrec catalog?

The ? as stated by someone else usually means that nothing was unloaded for some reason .. s04e, etc.
You stated that you have in your job records unloaded = xxxx
So, it looks like it worked on the unload.
The job that has the records unloaded .. is there a not cat2 in the output.
Look at the volume the sysrec that is in the output. Is it the same as the one with ?


Wayne Stevens
334-242-5686 Work
334-669-3033 Cell
888-535-1554 Fax

From: Nikhil Bhole [mailto:[login to unmask email]
Sent: Tuesday, July 18, 2017 4:00 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

________________________________
Attachment Links: recfm error.jpg (141 k) http://cp.mcafee.com/d/k-Kr4x0Sy_uXbzP3bVKVJ6WtQm6mhRPqdQT3hOMyY-yrhKOMeshd7bapJ6XdTTHIITdCdbg_GjYPYa0F0D7JfQxGKYhGpdE4UZF-AdlTydj9JBDX8e6zB_HYy--OCOqemeLsKCOYPOr8VddBZ_G8EHnjlKCDOEuvkzaT0QSyrsdTdTdw0F8dAu00UJzJsgHx92Fy1Ztgehq208tAwsY-yUr-cqNE05dxws-nAwShbETbILcfE44ttuIXtBSXbzRXEFCzAsqen_73DnwkvaAWt91IzM04SeKC-rdboscFBMGqnjh0nd41EE3y2pEw50Mc6y0cETd40c5NIQkCy09MQwvVEwDkQg7RR0Qgqq80UwCq81w3z0b6x8Qg8rfqvcQg69j9Cy05_qIk3h0bRyHI-XKV8Qg4zpEVKrMkWw
Site Links: View post online http://cp.mcafee.com/d/k-Kr4x0q43qbZXIKfccLCXCQrFThopp7ndETjsd7b2bPW9J6Xb0VN4QsIFCQrITvuKOPsSoQJ3-FfPfME2A2suQ_i6GXN6FASwjzSDWgRnu8RcCSmvIwUqen-LObXXar9EVoWZOWrbPf9IzAQSnT-EyyJtdmWqvaxVZicHs3jqpJMTsTsS02AwShU03ySeROAY9blFcV5Vd4sUQ40hIb7b8L9EzD0cmhujh7e6_z6Iq01joo7fBV8dAiWdOXbP3W117nnHeTptKOUZuWapEV76zB_NMVRU57OFeDigr8Y01dzHFLCPiS73apsaCBQQg5Ph0qa0UwCq81gc31Ew3adPh031srd59Ew2sd87-q89Rd41Ztgd46Cy0e89Cy0o0UM2NEid426PSDPd41ykOpEw1vSH50Qg2ZoGXfKXKid418SqerCOZqgm_WvQUkF View mailing list online http://cp.mcafee.com/d/FZsS839J5-ZSn7C6nPtPqdQXEIcIzHCQrFK6zBx5VZ4SztBwsUyqemkPqdSrLLnppKrcqmx_kDVDUk1i1efqvF3ltUzkOrg9NXjZ8qHL4qCjrbfSgsd7b_nV5ZZBdAQsItuVtdBVDAShOqrbX_khhmKCHtdfBgY-F6lK1FJASUrKrKr01igr8Y01Nr7qVim4FRmBoV4QsC_z6Iq01joo7fBV8dAiWdOXbP3W117nnHeTptKOUZuWapEV76zB_NMVRU57OFeDigr8Y01dzHFLCPiS73apsaCBQQg5Ph0qa0UwCq81gc31Ew3adPh031srd59Ew2sd87-q89Rd41Ztgd46Cy0e89Cy0o0UM2NEid426PSDPd41ykOpEw1vSH50Qg2ZoGXfKXKid418SqerC-wVUiUdikIX0 Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription http://cp.mcafee.com/d/1jWVIi4wUSy_uXbzP3bVKVJ6WtQm6mhRPqdQT3hOMyY-yrhKOMeshd7bapJ6XdTTHIITdCdbg_GjYPYa0F0D7JfQxGKYhGpdE4UZF-AdlTydj9JBDX8e6zB_HYy--OCOqemeLsKCOYPOr8VddBZ_G8EHnjlKCDOEuvkzaT0QSMrsdTdTdw0F8dAu00UJztcDn3vNzmd00FIc3DOYA6O9t6VtBVxZ0wzHHRDrIKTpsuLt5cQszzhO_UUsWY2zVkDjF8dAu00CNRQTPpFr3xBcK5jiWq82VEwd50sgjd40E61wQg1B6VEw1wKdCyAQg1e6A3_d44WCy0-KE6y3jh0744Ph0c0so1oQ96y13pXjVCy0NapcQg0LXlywq81uIltDTtT96y0Ard7dPpaasynlw

This email has been sent to: [login to unmask email]<mailto:[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 http://cp.mcafee.com/d/1jWVIidELTKOUYMO-rKrhKDt5xBAtsSztdMQsI8LfECQrII3D4jhOOCrhKPtZWXbdPpziQfWA_c_2wag9NXjZ8qHL4qCjq1efqvF3ltUzkOrpp-O3xEVvW_8LLIFICzBzHTbFILcYCOejjpvvWyaaRQRrFFYG7DR8OJMddLCT3tPtPo08q610d2kqJHsLAA6O9LUNH6w0kS61PVui3p4KzsKOYM-wghRRWPJSnrIKfnKyCqehNEVvYsetu1hYGjFQA6Of00joWWrVIQJxMOCn2FFtd41sQg6ywe89Cy0k30Mq80OzsQg0Mn6Phiq80D3i1_Cy2tjh0vnk3h1FEw3y2pEw60ec0Iq4zh0xIZFYPh0oBcCq80nZGNgd40LmaKPXKXAzh0idCzCVKU23771lloh_

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 http://cp.mcafee.com/d/5fHCN8p3xAqdELTKOUYMO-rKrhKDt5xBAtsSztdMQsI8LfECQrII3D4jhOOCrhKPtZWXbdPpziQfWA_c_2wag9NXjZ8qHL4qCjq1efqvF3ltUzkOrpp-O3xEVvW_8LLIFICzBzHTbFILcYCOejjpvvWyaaRQRrFFYG7DR8OJMddK6T3tPtPo0ai3p7w0ebppn3QctAwsCr-cqNE05dxws-nAwShbETbILcfE44ttuIXtBSXbzRXEFCzAsqen_73DnwkvaAWt91IzM04SeKC-rdboscFBMGqnjh0nd41EE3y2pEw50Mc6y0cETd40c5NIQkCy09MQwvVEwDkQg7RR0Qgqq80UwCq81w3z0b6x8Qg8rfqvcQg69j9Cy05_qIk3h0bRyHI-XKV8Qg4zpEVKr4glM

________________________________