Tiruvarur Classifieds

Ref: TVR36169
IBM Db2 DBA Administration
Lesson 1: Installation and the DB2 Editions
Db2 products and product components
Installation

Lesson 2: The DB2 Environment
Creation of instance
Creation of database
Lesson 3: Tools
Db2 control center
Db2 task center
Db2 clp
Db2 diagnostics
Db2 snapshots
Db2 problem determination
Lesson 4: Architecture
Memory model
Buffer pools
Hard parsing
Soft parsing
Tips and techniques
Lesson 5: Connectivity
Establish client server connectivity
Lesson 6: Working with database objects
Creating table spaces
Creating tables
Creating users
Creating indexes,views,aliases
Lesson 7: Data movement
Export
Import
Load
Db2move
Lesson 8: Security
Authentication
Authorizations
Concurrency and locking

Lesson 9: Backup & Recovery
Hot backup
Cold backup
Types of hot backup (database level and table space level )

Recovery scenarios :-
Crash recovery
Version recovery
Roll forward recovery
Dropped table recovery and few more
Lesson 10: Maintenance
Reorg
Runstats
Reorgchk
Optimizer ,advisor and binding

Lesson 11 : Troubleshooting and guide lines on performance tuning

Analyzing errors using diagnostics and notification files
Approaching db2support [Raising a PMR with IBM ]

Some Imp advanced concepts specifically for DATA WARE HOUSING ENVIRONMENTS [OLAP]

Lesson 13 : Introduction to Partitioning features [Table,data and Database]
BCU [Balance configuration unit] E7100 architecture
ISAS [IBM smart analytics system ] E7700 architecture

Lesson 14 : Enhancement and advantages of using different version of DB2 V9 and V 10
What’s new

Db2 version 9.1
Db2 version 9.5
Db2 version 9.7
Db2 version 9.8
Db2 version 10

Courses Offerings

• Abinitio
• Android
• AIX Administration
• Business Analyst
• CCNA, CCNP Security, CCIE
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• Hadoop
• HTML 5
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• IBM Websphere Transformation extender (WTX 8.2)
• Informatica
• I Phone
• Java/J2EE
• J Query
• MCITP
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS – HRMS
• Oracle APPS – SCM
• Oracle APPS - Manufacturing
• Oracle APPS – Financial
• Oracle APPS – Technical
• Oracle APPS – Project Accounting
• Oracle BI Apps
• Oracle BI Publisher
• Oracle DBA 11g
• Oracle RAC , Data Guard , Performance Tuning,
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• People Soft
• PHP
• Perl Scripting
• SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Tera Data
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB, RFT
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager & Identity Manager
• Unix Administration
• VN Ware
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webmethods
• Webservices , SOAP , REST ( JAVA)
• Windows 2012 server

Drop a mail info@futurepointtech.com we will get in touch with u
www.futurepointtech.com/ibm-db2-dba-administration-training.html

More details: IBM Db2 DBA Administration Training