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
 

 

What is the name of Recovery log table in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
Swetalina

New User


Joined: 11 Nov 2008
Posts: 30
Location: Bangalore

PostPosted: Tue Mar 31, 2009 10:59 pm    Post subject: What is the name of Recovery log table in DB2
Reply with quote

I have some questions.

1. Is there any program like 'Use Count'? If yes, what does it do?

2. What is the name of Recovery log table in DB2?

3. If Rewrite will be performed in a file and very next to that we will display the field, what value it will contain?

Low-values/High-values/Zeros/Rewritten record?
Back to top
View user's profile Send private message

Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1239
Location: Richfield, MN, USA

PostPosted: Wed Apr 01, 2009 3:42 am    Post subject:
Reply with quote

1. Use Count is usually associated with CICS and is the number of current users of a program.
3. None of the above if the 01 level is in the File Section. It will be unpredictable. See COBOL Language Reference.
Back to top
View user's profile Send private message
Swetalina

New User


Joined: 11 Nov 2008
Posts: 30
Location: Bangalore

PostPosted: Wed Apr 01, 2009 7:35 am    Post subject:
Reply with quote

Hi,
Terry Heinze wrote:
3. None of the above if the 01 level is in the File Section. It will be unpredictable. See COBOL Language Reference.


I could not get it. Can you please explain me in a more desriptive way.
Back to top
View user's profile Send private message
Swetalina

New User


Joined: 11 Nov 2008
Posts: 30
Location: Bangalore

PostPosted: Wed Apr 01, 2009 7:54 am    Post subject: Reply to: What is the name of Recovery log table in DB2
Reply with quote

Hi,

My question is if the Rewrite will be like this:

REWRITE rec_name FROM source_item

After the successful execution of this statement, immediately what will be the value in rec_name if we put a display for this.
Ans: High-values/Low-values/Zeros/Rewritten record.

Please help.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Wed Apr 01, 2009 8:07 am    Post subject:
Reply with quote

The COBOL Language Reference tells us:
Quote:
6.2.31.3 Reusing a logical record

After successful execution of a REWRITE statement, the logical record is no longer available in record-name-1 unless the associated file is named in a SAME RECORD AREA clause (in which case, the record is also available as a record of the other files named in the SAME RECORD AREA clause).
So absent a SAME RECORD AREA, COBOL tells us that rec_name will not be the rewritten record. Note that nothing is said about what the value in rec_name will be -- the value is as Terry said unpredictable. Not LOW-VALUES, not HIGH-VALUES, not ZEROES ... unpredictable.

Practically, the value will usually be either LOW-VALUES or a record previously in the program, depending upon the block size versus the record size, the number of buffers allocated, and other factors. Do not, however, count upon this since it will not be guaranteed.
Back to top
View user's profile Send private message
Swetalina

New User


Joined: 11 Nov 2008
Posts: 30
Location: Bangalore

PostPosted: Wed Apr 01, 2009 8:56 am    Post subject: Reply to: What is the name of Recovery log table in DB2
Reply with quote

Thanks Robert ..
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 -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm


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