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
 

 

DB2 version 10 upgrade.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Thu May 26, 2011 2:18 pm    Post subject: DB2 version 10 upgrade.
Reply with quote

Hi,

I have a question regarding SYSMAP dataset in the load job. Can you please help me to clarify this.

In production environment we have DB2 version 8. We have the DB2 load(DB2 LOAD Utility) jobs running in production and they do not have SYSMAP DD name defined in JCL. (Job has DD names SYSREC,SYSDISC,SYSERR). But the jobs are completing successfully.

But in test we have DB2 version 10 installed. And the same load job failing with message
"DSNU047I 145 01:46:53.89 DSNURELD - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSMAP".

Is it mandatory to define SYSMAP DD name in the DB2 version 10?. Or Since in production there were no error/discard occured and hence its not failing?.

Since in the test environment we have already using DB2 version 10, I am not able to test this myself.

Regards,
Chandra
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu May 26, 2011 2:31 pm    Post subject: Reply to: DB2 version 10 upgrade.
Reply with quote

nothing that the manual would not tell...
as for example here
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnugk13/2.14.2.1?ACTION=MATCHES&REQUEST=sysmap&TYPE=FUZZY&SHELF=DSNSHKA3.bks&DT=20081124094808&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

as You see there is a column where it says required/yes/no
find the same manual for db2 v10 and meditate accordingly

to check in the test environment load something where notes (3) and (5) do not apply
and see what happens ( should not take too much time )
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Tue May 31, 2011 2:37 pm    Post subject:
Reply with quote

Thanks Enrico. I will try this.
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Tue Aug 16, 2011 2:42 pm    Post subject:
Reply with quote

Hi,

I had tried to simulate the above case in test and job went fine.

However today we had first production run for DB V10, and the job failed due to SYSMAP error. We had quickly added SYSMAP DD name, and job ran fine.

But, there was no duplicate records in the input file. There were no records written into SYSDISC or SYSERR file.

Can you help me to understand if there are any ways to figure out what caused the error?

Regards,
Chandra
Back to top
View user's profile Send private message
akhi007

New User


Joined: 30 Jan 2006
Posts: 35
Location: Richmond

PostPosted: Wed Aug 17, 2011 1:43 am    Post subject: Reply to: DB2 version 10 upgrade.
Reply with quote

Chandra,

Does one or more tables are being loaded with the same load card which have unique indexes?
Did you mentioned ENFORCE CONSTRAINTS in the load card?

In any of the above cases is true, SYSMAP ddname is required.

HTH !!

Thanks,
Akhil
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Wed Aug 17, 2011 4:00 pm    Post subject: Reply to: DB2 version 10 upgrade.
Reply with quote

seemed to me that notes 3 and 5 of the link posted were clear about that icon_biggrin.gif
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 40
Location: Bangalore

PostPosted: Thu Aug 18, 2011 8:59 am    Post subject:
Reply with quote

Hi Akhil,

There was no ENFORCE CONSTRAINTS in the load card.

And there are other tables which had unique indexes loaded successfully with out SYSMAP. But only one table got this error.

Since there were no discards and error records I was not able to debug the problem.

Regards,
Chandra
Back to top
View user's profile Send private message
akhi007

New User


Joined: 30 Jan 2006
Posts: 35
Location: Richmond

PostPosted: Fri Aug 19, 2011 2:30 am    Post subject: Reply to: DB2 version 10 upgrade.
Reply with quote

Chandra,

Can you post your load card and the ddnames used other than STEPLIB, SYSRECxx SYSIN into the forum. I might help to identify the issue here.

Thanks,
Akhil
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 15 Tue Nov 01, 2016 11:24 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts CICS TS 5.3 migr after DFHCSDUP UPGRA... Kyle Carroll CICS 6 Wed Aug 31, 2016 10:58 pm


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