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 check pending, Disadvantage of LINK

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
sushilchandran

New User


Joined: 21 Jun 2005
Posts: 22

PostPosted: Mon Jul 11, 2005 10:39 am    Post subject: What is check pending, Disadvantage of LINK
Reply with quote

can anyone please let me out of these three questions

1)disadvantages of using link
2Parameters used in COBOL,CICS Program?
3)wat is check pending ?
Back to top
View user's profile Send private message

gowtham_srgp

New User


Joined: 09 Jun 2005
Posts: 38

PostPosted: Tue Aug 16, 2005 7:06 pm    Post subject:
Reply with quote

hai. check pending status with respect to my table resembles that the loading of the table to a ps file is in pending status due to the check pending of the primary keys.



corrections welcomed..........


gowtham
Back to top
View user's profile Send private message
mainframesguru

New User


Joined: 24 Jun 2005
Posts: 36
Location: Hyderabad

PostPosted: Wed Aug 17, 2005 11:40 am    Post subject:
Reply with quote

Hi Sushil,

The following are the answers:

1. The calling Program(with Link Option) expects control to be returned to
it. So this requires more overhead, and performance is relatively poor in
comparison to XCTL command.

2. The Question is not Clear to me.

3. Check Pending: It can be encountered in many ways.

Ex: A table is created and data is loaded. Now if you want to add a
constraint. But suppose, in the table there are few rows which doesn't
adhere to the new-constarint, in that case "Check Pending occurs". In that
situation,

a) Cancel the check Pending Status, using IBM Utility and then delete the
rows that are not adhering to constraint and then add constraint. (This is
not advisable).

i dont know, how it is dealt in real time.


Thanks And Regards
Vamshi
ICC-ISH
Chennai
Back to top
View user's profile Send private message
mfgpsall@yahoo.co.in

New User


Joined: 18 Aug 2005
Posts: 1

PostPosted: Thu Aug 18, 2005 11:10 pm    Post subject:
Reply with quote

1. when we call a program with link the called program will be stored in main memory and expects control to be returned back to the calling program and the instructions after link will be executed. So this requires more main memory and performance is relatively poor in
comparison to XCTL command.
in db2 programs if there no syncpoint before link command and the called program has exec-sql statements and its own plan then this can result in the called program refering to the plan of calling program.

regards,
ICC-ISH,
mainframer
Back to top
View user's profile Send private message
sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Thu Sep 01, 2005 7:13 pm    Post subject:
Reply with quote

hi,
when the table is loaded with ENFORCE NO operation,the table is left IN CHECKPENDING STATUS.TO RECOVER FROM THT U CAN USE REPAIR UTILITY.
REGARDS,
SATHISH
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts compile and link program in 6.1 brigitte pruett COBOL Programming 3 Tue Aug 16, 2016 12:09 am
No new posts Event-driven programming (BTS) VS (ST... Rohit Umarjikar CICS 2 Sat Jun 11, 2016 2:05 am
No new posts Syntax to check the first 4 digits of... kshirabdhi DFSORT/ICETOOL 10 Tue May 03, 2016 12:21 pm


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