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 SQLCODe -805 , Need information about Binding

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

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Sun Mar 22, 2009 4:05 am    Post subject: DB2 SQLCODe -805 , Need information about Binding
Reply with quote

Hi,

I have a question.

Originally Binding is happening(in my system) Whenever we move some components to an IMS region.

My question is, Normally if we promote a component to Production will the bind happends in all the lower region(Unit test regions) automatically.

Because in our case when we move a DB2 component to prodution we wont promote the same DB2 component to all the Unit test regions. So we will run batch DB2 jobs in Unit test region pointing to production load.

But after some days we will get -805(timestamp mismatch) in the DB2 batch jobs in Unit test region. Only if we promote the DB2 component again to Unit test region -805 is getting resolved.

My question why we are not getting -805 in unit test region after moving our code to production... and after few days we are getting -805 in the unit testing region.

During binding were the timestamp details will be stored and why its gettiing changed after few days.

Could any body help me with above question?

Thanks,
Nagu
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Mar 22, 2009 9:55 pm    Post subject:
Reply with quote

The timestamps get updated probably when some prod system stuff gets copied down to the test system in an effort to keep the test system as closely synchronized to the prod system as possible.
The database would be copied but the executible code wouldn't.....
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Mar 22, 2009 10:08 pm    Post subject:
Reply with quote

Hi,

There are some loose ends about which I would like to know - before I could attempt to answer:

1. For a DB2-Bind why this
Quote:
Whenever we move some components to an IMS region
is told (asked), in the context of your subject and question what does this line convey?

2. What is unit "test region" - kind of "testing" region?

3. When do you get -805, when you execute your code from "base-line" or when executed after some chnages in COBOL (probably) code?
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Sun Mar 22, 2009 10:15 pm    Post subject: Reply to: DB2 SQLCODe -805 , Need information about Binding
Reply with quote

Thanks much..

Do you know the table which has the timestamp details?

And also please tell me how to identify timestamp for load and dbr?

And also please tell me during run time how the timemismatch check will be done??? If its between Source and db2 tables please give me an example......

Thanks,
Nagu
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Sun Mar 22, 2009 10:20 pm    Post subject: Reply to: DB2 SQLCODe -805 , Need information about Binding
Reply with quote

Hi Arun,

Thanks for ur response...

Please find below details you asked,

1) This is the region which we promote DB2 component for testing.(Test region)

2)Unit test region is a test region which we use to test the code.

3)We will get issues when we run with baseline code...

Thanks,
Nagu
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Mar 22, 2009 11:45 pm    Post subject: Re: Reply to: DB2 SQLCODe -805 , Need information about Bind
Reply with quote

Nagendran wrote:
Hi Arun,
I'm Anuj . . . icon_smile.gif
Quote:
1) This is the region which we promote DB2 component for testing.(Test region)
And you still call it IMS-region . . . icon_wink.gif
Quote:
3)We will get issues when we run with baseline code...
If in those "few days" no other "version" of code is promoted to production, it should not happen..so I would like to go along with suggestion from CG ..at this point of time.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Mar 22, 2009 11:49 pm    Post subject:
Reply with quote

Hi,

Suggest you go through this link: Plans+DBRMS+Packages+Collections+Versions = Confusion till we make any further progress on this topic.
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 DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm
No new posts -419 SQL error when binding senthamizh DB2 2 Sun Jun 12, 2016 8:20 pm
No new posts Passing information through JCL as in... Pia Baruah JCL & VSAM 5 Wed May 25, 2016 2:22 pm


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