Explain in detail about buffer manager and its functionalities?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is dbkey?
What is the purpose of dd?
Let us say you have a collection of multiple maps in cics. So if you are asked to determine the exact storage space that is available in a symbolicmap, then how will you compute it?
What is the max length of sqlca?
how a data in physical and symbolic map gets treated? Since the physical map is much concerned about the screen alignment and the field positions, how the values entered in the field which has PICIN or PICOUT clause in Physical map gets treated? Does that mean datas recieved or sent to the physical map should be constant? How does the data in Symbolic map gets converted with 5suffix namely F,L,A,I and O. For example EMPNO is treated as EMPNOI, EMPNOO, EMPNOA, EMPNOL and EMPNOF. how does this happen in symbolic map. Please provide your inputs on the above and kindly correct me if I am wrong.
How can we retrieve the total number of records in RPG & CLLE?
what is eib, how is can be used?
what are s0c1, s0c4, s0c5, s0c7 abends?
what happens if parmparameter passes zero bytes to the program
What is sqlca?
What is the syncpoint command?
what are the reserved words for cics?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?