Super Web HuntSoftware download collection

* IBM Certified System Administrator – DB2 9 for z/OS

Section 1 – Installation and Migration (15%)
1. Given a scenario, demonstrate knowledge of the installation/migration plan process
2. Given a scenario, describe how to execute the installation/migration plan
3. Evaluate appropriate DSNZPARM settings

Section 2 – Security and Auditing (7%)
1. Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources
2. Describe auditing techniques
3. Describe role-based security and the advantage of deploying it

Section 3 – System Operation and Maintenance (21.5%)
1. Describe how to use and manage DB2 components and processes
2. Demonstrate knowledge of DB2 commands
3. Given a scenario, describe how to monitor an dcontrol DB2 threads
4. Demonstrate knowledge of DB2 commands

Section 4 – Backup and Recovery (20%)
1. Demonstrate knowledge of system level backup and recovery procedures
2. Given a scenario, describe how to recover from system failures
3. Describe the process for disaster recovery

Section 5 – Performance and Tuning (21.5%)
1. Given a scenario, analyze performance
2. Demonstrate knowledge of how buffer pools and ZPARMs can affect performance
3. Demonstrate knowledge of statistics, tools, and traces used for monitoring
4. Given a scenario, describe techniques to achieve efficient use of memory
5. Demonstrate knowledge of workload manager settings for DB2

Section 6 – Troubleshooting (15%)
1. Given a scenario, describe which documentation can be used to solve a problem
2. Demonstrate knowledge of operator commands and traces fro troubleshooting
3. Describe how to identify contention problems
4. Demonstrate knowledge of diagnostic utilities

More informations view: http://www.test4pass.com/000-737-exam.html easier way to success!

* IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
* IBM Certified Database Administrator – DB2 9 DBA for Linux, UNIX and Windows

Section 1 – Server Management (29%)

1. Understand the functionality of AUTOCONFIGURE
2. Ability to manually configure communications (protocol image(IPV6))
Section 2 – Data Placement (21%)

1. Ability to CREATE DATABASE (new default behavior)
2. Ability to create and manage Automatic Storage tablespaces
Section 3 – XML Concepts (13%)

1. Ability to use XML Data types
2. Ability to create and manage XML indexes
Section 4 – Analyzing DB2 Activity (16%)

1. Ability to use DB2 Utilities (db2bfd, db2mtrk, db2pd)
2. Ability to monitor deadlocks
Section 5 – High Availability (10.5%)

1. Ability to use RECOVER DATABASE command
2. Knowledge of High Availablity Disaster Recovery (HADR)

Section 6 – Security (10.5%)

1. Understanding of Label Based Access Control (LBAC)
2. Knowledge of new authentication types

More informations view: http://www.test4pass.com/000-736-exam.html easier way to success!

* IBM Certified Solution Developer – DB2 9.5 SQL Procedure Developer
Section 1 – SQL Procedural Language (30%)

1. Describe how to use the DECLARE statement
2. Demonstrate the ability to code assignment statements
Section 2 – DB2 SQL Procedures (26%)

1. Demonstrate knowledge how to identify proper usage of SQL procedures
2. Demonstrate knowledge of the fundamental structure of an SQL procedure statement
Section 3 – Functions (16%)

1. Demonstrate knowledge how to identify proper usage of functions
2. Demonstrate the ability to use the CREATE FUNCTION statement
Section 4 – Triggers (10%)

1. Demonstrate knowledge how to identify proper usage of triggers
2. Demonstrate the ability to use the CREATE TRIGGER statement
Section 5 – Advanced SQL Features (12%)

1. Demonstrate knowledge of Declared Global Temporary Tables
2. Describe how to use system features

Section 6 – Related Tools (6%)

1. Demonstrate knowledge of application development tools

More informations view: http://www.test4pass.com/000-735-exam.html easier way to success!