Mainframe For Dummies

    DB2-CICS Program Compilation and Execution  Process   1) Write a DB2/CICS program and compile it using DB2/CICS compailer JCL 2) Use BIND JCL for binding process 3) Now Sign on to CICS Region. 4) Define and install the Map . 5) Define and Install the Program. 6) Check whether there is any DB2 Connection. If not Create a connection using ceda def db2c(....) 7) Define and install the DB2 Entry using ceda def db2e(.......) 8) Define and install the DB2 Transation using ceda def db2t(.......) 9) Define and install the Transation 10) now your setup is ready and you can run your program using the transation ID Sample Screen shots – used for defining above process 4a. Define the map : MYMAPS 4b. Install map : MYMAPS 5a. Define the Program : PGM 5b. Install the Program : PGM 7b. Define the DB2ENTRY : VINAY 7b. INSTALL the DB2ENTRY : VINAY 8.a. DEFINE the DB2ENTRY : HARI 8.a. INSTALL the DB2ENTRY : VINAY GROUP = VIJAY 9.a. DEFINE the transaction for the program(Pgm) : VBVB 9.b...

Why DB2 and why not VSAM (DB2 Vs VSAM)? This is the common query raised by the programmers, whether to go with DB2/VSAM, hope below information helps. VSAM DB2 Definition Database with file Concepts Database built on File management storage system-DBMS concepts Security levels Provides at Dataset level only Provides Good security levels at various levels (like table, table space etc.,) Data Maintenance It’s difficult compared to DB2. Data retrieval or insertion or updates etc, is a bit difficult (puts more burden on programmer to achieve this). Simply speaking Query interface is not supported It’s easy to maintain data by using SQL Data retrieval or insertion or updates etc, is far easier using SQl . Query interface is ...

Write a DB2/CICS program Compile it using DB2/CICS compailer JCL Use BIND JCL for binding process Now Sign on to CICS Region. Define and install the program. Define and install the Transation. Check whether there is any DB2 Connection. If not Create a connection using ceda def db2c(....) Define and install the DB2 Entry using ceda def db2e(.......) Define and install the DB2 Transation using ceda def db2t(.......) now your setup is ready and you can run your program using the transation ID

Future for Mainframes in SOA While it is far too early to get an answer it is now possible to ask, as a serious rather than trivial question, whether there is scope to see new sales of zSeries mainframes grow into the SOA and web services-based market sectors as a result of new developments in integration tools, such as the recent appearance of DataDirect Technologies' major upgrade of its Shadow integration platform, for the traditionally back-office machines. Will it be enough to prove to be a positive lever on green field zSeries sales? It might still be a brave person who answered ‘yes’ right now, the opportunity now exists where the mainframe can start to play a full part in a web-services/SOA environment, running applications that can proactively participate in that environment rather than just be a passive contributor to it. While it may not be natural to think of a mainframe as a core system in such an environment, Version 7 of Shadow does offer the potential to move IBM...

Impact Analysis : I hope Below informaiton will provid you brief information on various steps involved in impact analysis ( when ur asked to add a new field?) Impact Analysis : This is a process to identify the various Copy books or Programs of Jcls or DB2 table etc are to be modified/impacted due the new changes , to meet the requirement.As per the requirement, programmer will have an idea, like what are the New fields/Existing field to be added/modify in 1. Copy Books 2. Files/Jcl 3. Database 4. In online Screen etc. 1. Impact Analsys On Copy Books (used by cobol programs) : Identify the copybooks to be modified as part of requirement in list1 Now search for various copy books Impacted because of the copy books listed in list1 and note them into new list List2 Now search for various copy books Impacted because of the copy books listed in list2 and note them into new list List3 Above process is continued till the search returns zero copy books impacted. Merge all above lists and eli...

walkin for Freshers -- TCS HYD Students who have just completed their graduation/post graduation can apply for trainee positions.) for technical writr position . Eligible candidates can walk in for a written test and interview at TCS, Deccan Park on Saturday, 07 June 2008, at 10:00 am. .........----------------------------------------------------- ----------------------------------------------------------------- Req for DELL Hi all please forward your 2007 & 2008 passed out resumes to belowmentioned emails.Dell is planning to recruit more than 1000 new graduates for their new webmail development, in various locations. This is Great Opportunity for FreshGraduates to work with DellQualification:ØBE / B. Tech. - 2008 pass outs (Computer Science, Information Technology,Electronics and all Electronics, Electronics & Telecommunication,Electronics & Instrumentation etc.) Ø MCA / M.Sc. -2007/08: Only ComputerScience & Information Technology Branch Ø B.Sc./BCA - 2007/08: Comput...

Exam Name: IBM DB2 UDB V8.1 Database Administration Exam Code: 000-701 Question: 1 Given the following command Create database payroll alias paynew on path/drive Using codeset codesst Territory territory Collate using identity How is character data compared within the database? A. Byte for byte B. Based on the codest C. Based on the codepage D. Based on the territory Answer: A Question: 2 Given the following statement Drop table payroll. Employee" Returns the following message. Solo55in "user" does not have the priviege to perform operation "drop" on object "pavroll. Employee." Sqlstate=42501 Which of the following will correct the situation? A. GRANT DROP AUTHORITY TO user1 B. GRANT DROPIN ON SCHEMA user1 TO user1 C. GRANT DROPIN ON SCHEMA payroll TO user1 D. GRANT DROPIN ON SCHEMA employee TO user1 Answer: C Question: 3 Which of the following is required to support infinite active log space? A. USEREXIT = ON, LOGSECOND = 0 B. USEREXIT = ON, LOGSECON...