Mainframe For Dummies

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

In DB2, the columns defined as NULL needs to be handled carefully else it will throw null exception error, in order to over come this error data type can be handled by using null indicator . NULL is stored using a special one-byte null indicator that is "attached" to every nullable column. If the column is set to NULL, then the indicator field is used to record this. Using NULL will never save space in a DB2 database design - in fact, it will always add an extra byte for every column that can be NULL. The byte is used whether or not the column is actually set to NULL. The indicator variable is transparent to an end user Consider below Table : Create Table SAMP_TAB SN CHAR (10) SNAME CHAR (10) STATUS CHAR (2) NOT NULL BY DEFAULT CITY CHAR (10) NOT NULL Note :: Unless you specify NOT NULL, the default is to allow for NULL In above table SN and SNAME columns holds null values by default, in order to handle these null variables we need to have NULL-INDICATORS declares in the Pro

Question: HOW MUCH SPACE OS ALLOCATES WHEN YOU CREATE A PS OR PDS? Answer: 56 KB Question: MIN NO OF DATASET NAMES (PDS) IN ONE DIRECTORY BLOCK? Answer: FOUR - SIX Question: THE MAXIMUM NUMBER OF STEPS IN A JOB? Answer: 255 Question: MAX. NO OF DD STATEMENTS IN A JOB Answer: 3273 Question: What is the maximum number of instream procedures? Answer: 15 Question: for how long a job can be executed continuously in a mainframe Answer: 248 DAYS Question: How much is memory space involved, when we code BLOCKSIZE,TRK & CYL Answer: One block constitutes 32KB of formatted memory/ 42KB of Unformatted memory, 6 blocks makes one Track & 15 Tracks makes one cylinder. Question: What is DSNDB06 ? Answer: This is the Place where DB2 Catalog resides Question: What is the use of DSNDB07 ? Answer: This is the area where sorting takes place in DB2 Question: WHAT IS DATACOM DB? Answer: IT IS A DATABASE USED WITH VSE. Question: What are the maximum and minimum sizes of any CONTROL AREA (VSAM datas

Relational Database Management System(RDBMS) Universal Database(UDB) This is one of the sub systems in Mainframes. Any number of Sub Systems can be created in Mainframes as per the requirements. Hierarchy of DB2 Sub system: TS – Table Space INS – Index Space T – Table IND – Index V – view Maximum storage space for a Table Space is 64 million bytes. SQL can be used to Create, Delete, and Update and Query the Objects SQL queries can be executed by the following techniques Application programming Tools like QMF (Query Management Facility) SPUFI (SQL Processor User File Input) DATA TYPES : Integer -- 4 bytes Small int -- 2 bytes Char(n) – N bytes Varchar(n) – N+2 bytes Graph(n) – 2n bytes Vargraph(n)– 2N+2 bytes Date – 10 bytes Time – 8 bytes Timestamp – 26 bytes NORMALIZATION : Arranging the data in the Database in organized manner. 1NF: Avoiding multiple values or set of values in one column. 2NF: Avoiding repeated rows by defining primary key. 3NF: Separating functionally dependent