Transcription
IBM MainframeDURATION: 48 HoursBM Mainframe Concepts Mainframe Concepts Basic IBM Architecture OS ConceptsJCL – Job Control Language1 Basic concept of JCL JOB StatementPositional ParametersKeyword Parameters EXEC ParametersPositional Parameters of EXEC StatementsPARM ParametersCOND Parameters JOB and EXEC (Additional Parameters) JOBLIB and STEPLIB StatementsADDRSPCDPRTYPERFORMRD DD (Data Definition) StatementsDSN Parametero Qualified and Non-qualified namesTemporary Data SetDISP ParameterSTATUS fieldsNormal and Abnormal Disposition UNIT, VOL and LABEL ParametersSerial No, Refer back Private, Label, Retain, Defer, AFFPassword, IN, OUT, EXPDT, RETPD SPACE and DCB ParametersTRK, CYL, Primary, Secondary, DirectoryRLSE, CONTIG, MAXIG, ROUNDRECFM, LRECL, BLKSIZE, BUFNO Coding Data Sets, and I/O on DD ODOUTLIM In-Stream and Catalog ProceduresPROCPENDOverriding ParameterSymbolic Parameter Generation Data Group (GDG)Rules for coding GDGFeature of GDGAdvantage of GDGGDG ModelIDCAMS Utility Define, Limit, Empty, No EmptySoftwarePartner 2006
Scratch, No Scratch, Delete, Purge, Force Utilities ProgramsIEBGENERIEBCOPYIEHPROGMIEBCOMPRIEFBR14 SORT/MERGE UtilitiesExternal SortingParameters and Sub Parameter of Sort UtilityMerge FunctionSort Queries Compile, Link Edit, and RunCompiler Program (IGYCRCTL)Link Editor Program (IEWL)Compiler OptionsCOBOL – Common Business Oriented Language2 Introduction of COBOLCoding format for COBOL programCharacter Sets,LiteralsIdentifiersFigurative Constants COBOL Divisions and SectionsID, Environment, Data, & Procedure DivisionConfiguration SectionInput-Output SectionWorking-Storage SectionLinkage Section o File Section COBOL VerbsData Movement VerbsArithmetic VerbsSequence Control VerbsInput Output VerbsCondition VerbsCategories of COBOL Statement Writing Complete ProgramsCompile and programRun a COBOL programProgram Testing Usage lification of Data Names Conditional and Sequence Control VerbsRelational, Sign, Class, Condition-Name, Negated, and Compound conditionsIF StatementEvaluate StatementPerform StatementEXITALTER etc. Table HandlingOccurs clause and Sub scriptingAssigning value to table elementsMulti-Dimensional TableIndexed Table and IndexingSET VerbSearch Verb Sorted tables and binary search Searching a Multi-dimensional tableSorting a TableIndex Data Items Structured ProgrammingProgram DesignObjectives and Methodologies of Structure ProgrammingSoftwarePartner 2006
Structure Programming in COBOL Three Basic statements Modular Programming in COBOL Combination of Basic Structures File HandlingSteps in file handlingAllocation of fileDefining the file in file sectionOpen Statement Input Output ExtendOpen and Close for Tape file Sorting and Merging filesSimple Sort VerbFILE UPDATIONSimple Merge VerbInput and Output Procedure in Sort StatementMerge Verb with Output Procedure Character HandlingString VerbUnstring VerbInspect Verb COBOL SubroutinesStructure of a SubroutinesCalling of SubroutinesState of a Subroutine and Cancel statementVSAM (Virtual Storage Access Method) VSAM overview VSAM Advantage and Disadvantage CLUSTERS Data organization of VSAMKSDSESDSRRDSLDS Internal Organization of VSAMControl IntervalControl AreaFree SpaceCA, CI Split Accessing VSAM Data SetUsing KEY, RRN, RBA Repro Record Selection Export, Import, Delete, LISTCATAlternate Index Need of AIX Define Alternate Index BLD Index Define path APM Parameters in JCLAMROGBUFNDBUFNIBUFSPDb23 Introduction to RDBMSRelational ConceptCODD's Relational Rules Overview of DB2/VDB ver. 7 for OS/390DB2 Migration from OS/390 to Z/OS DB2 ObjectsSystem Objects DB2 Catalog DB2 DirectorySoftwarePartner 2006
4 Bootstrap Data Set Active and Archive Logs Buffers Spools Locks Data ObjectsSTOGROUPDatabaseTable SpacesTableIndexesViews Structure Query Language (SQL)Data TypeDB2 Database DesignDB2 Table ParametersReferential IntegrityDDL Create Alter DropDML Insert Update DeleteDCL GRANT REVOKEColumn and Scalar functionsSorting and GroupingJoin and Sub queries Inner Join Outer Join Left Outer Join Right Outer Join Full Outer JoinSub queriesCorrelated sub queriesUnion and Union AllViewAliasSynonymsSPUFI (SQL Process Using File Input)QMF (Query Management Facility) DB2 InterfacesDCLGEN DB2 Application Development OverviewDB2 Program Preparation StepPre compilationBinding Compile the Program Link the ProgramDBRM (Data Base Request Module)PLANPackageEmbedded SQLModifying Data with Embedded SQL Host Variables Host Structures Null Indicator Variables Cursor ProcessingProgramming with CursorUsing Cursor for Data Modification SQL Execution ValidationSQLCASQL CodeSQL StateSoftwarePartner 2006
Error Handling Advance SQLDynamic SQL Vs Static SQLDynamic SQL & PerformanceFixed List Select StatementTriggers Performance Monitoring/TuningDB2 OptimizerInfluencing the Access PathAccess Path & OptimizerExplain Function Locking and ConcurrencyLocking DataPage Lock ModesLock DurationsIsolation OptionsTime outs and Dead locks DB2 UtilitiesRUNSTATSREORGCHECKMERGECOPYLOAD DB2 Environment with OS/390 & Z/OSDB2 with CICSDB2 with TSOCall Attach FacilityRRSAFCICS – Customer Information Control System5 Introduction to CICSBatch and Online: DifferencesFeatures of CICSCICS System ServicesTask & TransactionControl Programs (or Management Module) Control Tables Control Blocks CICS Unique FeaturesMultitaskingMultithreadingReentrantQuasi Reentrant CICS Command Format Execution of CICS ApplicationTerminal Conversion Conversation Non Conversation Pseudo Conversation Exceptional ConditionsHandle ConditionIgnore ConditionPush and Pop CommandsRESP optionAttention Identifier Keys(AID) CICS Program Control CommandsLink CommandXCTL CommandReturn Command Interval and Task ControlASKTIMEDelayFormat TimePOST and WAIT EVENT CommandsSTART CommandCANCEL CommandSUSPEND Command Basic Mapping Support (BMS)SoftwarePartner 2006
Primary function of BMSMAP and MAPSETTypes of Maps Physical map Symbolic mapReceive mapSend mapText Building Commands Send Text Text Header and Footer Cursor Pointing Techniques Number sign/Decimal point File ControlVSAM KSDS ESDS RRDSDefining fileRandom readSequential readSTARTBR QueuesTransient Data Control WRITEQ TD Command READQ TD Command DELETEQ TD Command Destination Control Table Automatic Task Initiation Design Considerations for TDQTemporary Storage Control WRITEQ TD Command READQ TD Command DELETEQ TD Command Design Considerations for TSQ System SecuritySign-on Table (SNT)Transaction SecurityResource Access Control Facility (RACF) Test and DebuggingHANDLE ABEND CommandDUMP CommandTrace ControlExecution Diagnostic Facility (EDF)Command Level Interpreter (CECI)Temporary Storage Browse (CEBR)Master Terminal Transaction (CEMT)Dynamic File Open/Close (DFOC)Tools6 ENDEVOR (Version Control Tool)Perform Display functionExecute Foreground actionPerform Batch action processingDefine or Modify Environment information.Perform Foreground Package ProcessingBatch Package SCL Generation Xpediter (Debugging Tool)Prepare program for debuggingDebug program interactively under TSO/BatchDebug DB2 Stored proceduresUtility Functions FILE AID (File Handling Tool)Display File ContentsCreate or Change File ContentsFile Aid / ISPF Extended UtilitiesPrint File ContentsSoftwarePartner 2006
Create of Change Selection CriteriaCreate or Change record layout cross referenceView Interpreted LayoutConvert file from one formatCompare File ContentProjects Types of Mainframe Projects Mainframe Project Life Cycle.Salient Features:Individual /Corporate Training.Daytime, weekends, evenings and flexible hours available.Personal attention to everyone.Highly experienced faculty with Real-time scenarios.Placement assistance after the training.Discounts to group students / Professionals.Small Batches for individual attention.Course Duration : 3 Month7SoftwarePartner 2006
DB2 Optimizer Influencing the Access Path Access Path & Optimizer Explain Function Locking and Concurrency Locking Data Page Lock Modes Lock Durations Isolation Options Time outs and Dead locks DB2 Utilities RUNSTATS REORG CHECK MERGECOPY LOAD DB2 Environment with OS/390 & Z/OS DB2 with CICS DB2 with TSO Call Attach Facility RRSAF Introduction .
