Mainframe For Dummies

Cobol,Jcl,Db2 related Interview Qns How to identify a file declared in Source (cobal pmg only) is a VSAM file (ESDS.) or not. AS(Address Sequential ) as to prefixed to the logical name Eg :: select File1 assign to AS-FILE11 Check the FD section :: we declare ORGANISATION IS SEQUENTIAL/INDEXED/ RANDOM File status code (23 eof) How do create VSAM files Using IDCAMS / File Aid / Workbench (these tools internally uses idcams) How do u identify a file to be created is ESDS/KSDS/RRDS – by looking at Cluster create statements . ESDS will have :: Data and Cluster Datasets KSDS will have :: Index,Data and Cluster Datasets RSDS will have :: Data and Cluster Datasets Other Important Point is in Cluster Declaration, we declare Index, Non-Indexed and Numbered for KSDS/ESDS/RRDS How do u identify whether VSAM file is Fixed or VB. If Record Size (F,F) -- > fixed, if Recordsixe (F,V) -- > Variable How do you identify the dataset is VSAM dataset or not by looking at the Job . Check the DCB param

1. What r the 2 function we can get by using INSPECT verb? (c) A. file handling, error handling B. opening a file, closing a file. C. char counting, replacing. D. none of the above 2. Indicate which of the following is not true about the formal parameters in a subroutine? (c) A. every formal parameter must appear in the linkage section of the subroutine B. every formal parameter must appear in the using phrase of the procedure division header of the subroutine C. A formal parameter name can appear more than once in the using phrases of the procedure division header of the subroutine. D. A formal parameter can not be declared with value clause in a subroutine 3. What is the value of A? (B) 01 A pic 9(3). Move 100 to A. Perform 1000-para thru 1000-exit. Display the value of a=A Stop run. 1000-para. If A=100 Perform 1000-exit Else Move 150 to A End-if. Move 200 to A. 1000-exit. Exit. a.100 b.200 c.150 d. none of the above is correct. 4. What is the value of B? (A) Move 1 to A Evaluate tr

IKJEFT01 – Terminal Monitor Program (TMP) We can Invoke DB2 subsystem in three ways 1. SPUFI 2. QMF and 3. IKJEFT01 --- Here we discuss more about this TMP. IKJEFT1A and IKJEFT1B are not utilities but are rather two alternate entry points for the TSO Terminal Monitor Program initialization routine, IKJEFT01 . The DB2 utilities were written to run under TSO, either under a terminal session or in batch. If you have access to the JCL used to start your TSO sessions, you will see that on the // EXEC statement, PGM=IKJEFT01 most likely (or, in some cases, ADFMDF03, which is a part of TSO/E called the Session Manager which, at shops enlightened enough to run it, calls IKJEFT01 in turn). When running the TMP in batch, in order to have TSO execute a series of TSO commands asynchronously, you can use PGM=IKJEFT01, IKJEFT1A or IKJEFT1B. The following is taken from the TSO/E User's Guide for z/OS 1.4, section 3.4.4.1.2: “PGM= “ specifies the module being executed. In addition to IKJEFT01, t

CHECKPOINTING & RESTART IN BATCH PROGRAMS IN CASE OF ABENDS The Concept of Check pointing is to Save the data permanently in the database till the Last Checkpoint in case of an Abend in the Program after taking a Checkpoint. In the case of an abend the DBA will automatically back out (reverse) the changes made to the Database after the Checkpoint. So if we RESTART the Program after an abend, the program will use the Last Check pointing Information for restarting. There are various ways for Checkpoint/Restart. 1. With the Help of a Restart File: - This type of Check pointing will need a Restart File. In this type, while taking each Checkpoint we will store the Checkpoint ID, with the Necessary Save Area in CC5DAP database. The Checkpoint ID will be usually the Time at which that particular Checkpoint was taken. For Restarting this type of Programs, there will be two Steps. The first step will put the Stored CC5DAP data corresponding to the Last Checkpoint to a Restart File. The Seco

Oracle 11 i Applications Architecture The Oracle Applications Architecture is a framework for multi-tiered, distributed computing that supports Oracle Applications products. In this model, various servers are distributed among multiple levels, or tiers . Oracle Applications Architecture The Desktop Tier The client interface is provided through HTML for the newer HTML-based applications, and via a Java applet in a Web browser for the traditional Forms-based interface. Forms-based Desktop Tier Architecture In Oracle Applications Release 11 i , each user logs in to Oracle Applications through the E-Business Suite Home Page on a desktop client web browser. Forms Client Applet The Forms client applet is a general-purpose presentation applet that supports all Oracle Applications Forms-based products, including those with customizations and extensions. The Forms client applet is packaged as a collection of Java Archive (JAR) files. The JAR files contain all Java classes re

Tips for Telephone interview: Telephone contact means that there are no visual clues unlike a face-to-face interview, In a telephone interview you have to sell yourself using only words and the tone of your voice Smile! Amazing as it might sound, smiling whilst you talk really helps. You will come across as more friendly and confident. Try it! Few Minutes Before Telephonic: Should have compile list of : • Your strengths and weaknesses • Your background and skills, • Answers to typical interview questions Make sure you have : • Keep your resume in clear view, so it's at your fingertips when you need to answer questions. • Have a pen and paper handy for note taking. • Turn mobile phones off, so your call isn't interrupted • Practice reducing "ums" and "uhs" and "okays" During the Interview: • The first 15 seconds are crucial and interest in your voice is the key. Just the way you answer th

• Utilities – Image Copy – CDB SuperCopy – Quiesce – Load – CDB SuperLoad – Check – BSCTIAUL – CDB SuperUnload – Recover – CDB SuperRestore – Reorg – CDB SuperReorg – Runstats – Report Recovery – Repair • Commands – Display/Stop/Start Database – Display/Term Utility DB2 Logging • DB2 Logs – A ‘journal’ of all activity for a subsystem – Undo/redo records for table updates – Each event in the log is identified by its RBA(relative byte address) – RBA denotes a point in time: the greater the RBA, the later in time the event occurred – Data Sharing - LRSNs along with RBAs – Some events: • Full image copy • Quiesce • Load Data Sharing • Benefits of Data Sharing – High availability – Workload balancing – Sysplex parallelism – Better use of resources Backing Up Tables • Image Copy – Backup for DB2 table spaces – Can also copy index spaces – Can perform full (all data) or incremental (changed data) copies – Can prevent or allow updates by others during copy – SAMPLIB: DB2COPY • CDB

1. How to reconnect to Mainframes session when system says User already login ? In Login Page check the Reconnect option with ‘S’ and then logon .. it will reconnect to the mainframe session 2. What is the basic use of directory blocks while creating pds ? Directory blocks work like an index to the PDS and contain the member names of what is stored in the PDS. A directory block can hold approximately 6 member names so a PDS with 2 directory blocks can hold approximately 12 members and a PDS with 3 directory blocks can hold about 18 members 3.How to find How many members dose PDS has without opening it? Open member in 3.4 optin and put ‘I’ to see the above information. 4.What is RESTART Parameter in JCL ? RESTART Parameter is used to restart a job from specified/abended step manually. Below step shows how to start from step2 by skipping step1. Eg: //Job1 Job Class=A, Restart = step2 //step1 : //step2 5.How do you edit /resubmit a job which is available in spool ? Use commands SJ or SE a