tag:blogger.com,1999:blog-31301843577717513592024-03-13T14:33:20.907-07:00DB2 DBA training on z/OSRao DBAhttp://www.blogger.com/profile/17574023589855809805noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3130184357771751359.post-36274945891715399852013-04-16T08:50:00.001-07:002013-04-16T08:50:41.657-07:00<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
DB2 DBA training on z/OS - </h2>
<br />
<h3 style="text-align: left;">
DB2 Overview </h3>
<div style="text-align: left;">
Introduction to DB2 for z/OS<br />An Overview of DB2 and Information management </div>
<h3 style="text-align: left;">
<br />DB2 Concepts </h3>
DB2 data Structures <br />DB2 Tables<br />An Overview of DB2 and Information management <br />DB2 indexes<br />DB2 keys<br />DB2 views<br />DB2 schemas and schema qualifiers<br />DB2 table spaces<br />DB2 index spaces <br />DB2 storage groups<br />DB2 databases<br />DB2 Synonyms<br />DB2 Alias <br />
<h3 style="text-align: left;">
<br />DB2 system objects</h3>
<div style="text-align: left;">
DB2 catalog <br />DB2 directory<br />Active and archive logs<br />Bootstrap data set<br />Buffer pools<br />Data definition control support database<br />Resource limit facility database <br />Work file database </div>
<h3 style="text-align: left;">
</h3>
<h3 style="text-align: left;">
DB2 commands</h3>
DB2 and related commands like<br />START DATABASE (DB2)<br />STOP DATABASE (DB2) <br />DISPLAY DATABASE (DB2)<br />ACCESS DATABASE (DB2) <br />
<h3 style="text-align: left;">
<br />Catalog and Directory</h3>
<br />Catalog Tables: <br />SYS IBM.SYSTABLES<br />SYS IBM.SYSCOLUMNS <br />SYS IBM.SYSDATABASE<br />SYS IBM.SYSSTOGROUP <br />SYS IBM.SYSTABLESPACE <br />SYS IBM.SYSINDEXES etc ... in DB2 ver 9.1 <br />
Directory Tables: <br />SPT01 <br />SCT02 <br />DBD01<br />SYSLGRNX<br />SYSUTLIX <br />
<h3 style="text-align: left;">
<br />DB2 Utilities</h3>
Introduction to the DB2 utilities <br />
<br />DB2 on line utilities like<br />CHECK DATA <br />CHECK INDEX <br />COPY <br />COPYTOCOPY <br />LOAD<br />UNLOAD <br />
RECOVER<br />REORG<br />REPAIR<br />MODIFY <br />MERGECOPY <br />REPAIR , REPORT etc .... All the Utilities ....<br />
<br />DB2 stand-alone utilities like<br />DSN1CHKR<br />DSN1COMP <br />DSN1COPY etc .... <br />
<h3 style="text-align: left;">
<br />Performance Tuning </h3>
Planning your performance strategy <br />Designing your system for performance <br />Programming DB2 applications for performance <br />Tuning your queries<br />Programming for concurrency <br />Working with PLAN_TABLE using EXPLAIN statement <br />
<br />SQL statements <br />
</div>
Rao DBAhttp://www.blogger.com/profile/17574023589855809805noreply@blogger.com0