Arich Infotech

IBM DB2 Administration

TopicLearnings
Introduction to DB2DB2 Address Spaces, System Services Address Spaces (DSNMSTR), Database Services Address Spaces (DSNDBM1), Internal Resources Lock Manager (IRLMPROC), Distributed Database Facility (DSNDIST), Storage Procedure Address Space (DSNSPAS),
DB2 Physical ObjectsDB2 Catalog, DB2 Directory, Active & Archive Logs, BSDS, Buffer Pools, Lock
Database DesignPhysical design Process, Object Design Storage Groups, Databases, Table space, Tables, Data Types, Indexes, View, Constraints, Primary Key & Foreign Key, DB2 Catalog
Program Preparation / BindDB2, DSN Commands, Program Preparation, DCL Gen, Pre-Compilation, Bind Package & Plan
Locking and ConcurrencyLocking, Locking hierarchy, Transaction locks, Table space locks, Releasing locks, Releasing Page / Row Locks, Concurrency Options
Security & ControlExplicit privileges, Database Privileges, System Privileges, User Privileges, Schema Privileges, Grant & Revoke Privileges
DB2 Online UtilitiesLoad & Check Data, Check Index, Reorg, Repair, RUNSTATS, Modify, STOSPACE, Backup & Recovery, Copy, Recover, Quiesce, Report, MERGECOPY
DB2 Standalone UtilitiesDSN1COPY, DSN1LOGP, DSN1PRINT, DSNJLOGF, DSNJU003
DB2 and Other environmentConnectivity definition, Call Attachment facility, CICS Attachment facility options, TSO Attachment facility options
Performance ManagementPerformance Management definition, Optimizer, Performance Tuning, Explain Function, Plan-Table.

    Enquire About Our Courses

    If you have any questions about our courses or need more information, please fill out the form below, and we'll get back to you shortly!