IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 SQLCODe -805 , Need information about Binding


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2146
Location: At my coffee table

PostPosted: Sun Mar 22, 2009 9:55 pm
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

Superior Member


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

PostPosted: Sun Mar 22, 2009 10:08 pm
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
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
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

Superior Member


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

PostPosted: Sun Mar 22, 2009 11:45 pm
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

Superior Member


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

PostPosted: Sun Mar 22, 2009 11:49 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Extract all the TWS scheduler informa... IBM Tools 1
No new posts Table Information - DB2 DB2 1
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
Search our Forums:

Back to Top