精华区文章阅读

发信人: superman (☆风雨无阻☆), 信区: Database
标  题: DB2 UDB V5 503-507obj !
发信站: 紫丁香 (Sun Sep 20 16:26:00 1998), 转信

Test Objectives for Test #503 - DB2 UDB V5 Fundamentals

Installation and Planning (15-20%)

1.Given a situation, identify when to use DB2 Personal/Workgroup/Enterprise
  Edition.
2.Identify characteristics of DB2 Personal/Workgroup/Enterprise
  Edition.
3.Identify characteristics of DB2 Client Application Enabler (CAE).
4.Identify characteristics of DB2 Personal and Universal Developer's Edition.
5.Given a situation, identify when to use DB2 Connect.
6.Identify and explain the factors contributing to the size of a DB2 database.
7.Identify the software requirements for DB2.
8.Identify and explain the hardware requirements for DB2.
9.Identify licensing for DB2 UDB/Connect/Developer's Edition.
10.Given a situation, identify the license requirements for DB2 UDB/Connect/
   Developer's Edition.
11.List communications protocols supported by DB2.
12.Identify required software for DB2 Client/Server scenarios.
13.Install DB2 Universal Database.
14.Install DB2 CAE and Developer's Edition.
15.Configure DB2 clients and servers using APPC/NETBIOS/TCPIP/IPXSPX/NPIPE.

Security and Instances (15-20%)

1.Invoke the Command Line Processor and Command Window.
2.Describe the functionality of the Control Center.
3.Describe the functionality of the Administration Server Instance.
4.Create DB2 groups.
5.Create DB2 users.
6.Create DB2 instance using db2icrt and dasicrt.
7.Given a situation, identify required DB2 instances.
8.Identify characteristics of an instance.
9.Identify the active instance.
10.Identify database security groups.
11.Provide users with authority on database objects.

Creating and Accessing DB2 Databases (10-15%)

1.Create a DB2 database.
2.Interpret the contents of the system database directory.
3.Interpret the contents of the node directory.
4.Interpret the contents of the local database directory.
5.Catalog a node.
6.Catalog a remote database.
7.Catalog a local database.

SQL Usage (15-20%)

1.Given a DDL SQL statement, identify the results.
2.Given a DML SQL statement, identify the results.
3.Given a DCL SQL statement, identify the results.
4.Use SQL to SELECT data from a single-table.
5.Use SQL to SELECT data from multiple-tables.
6.Use SQL to SORT data.
7.Use SQL to UPDATE data.
8.Use SQL to DELETE data.
9.Use SQL to INSERT data.
10.Identify the affect of a COMMIT statement.
11.Identify the affect of a ROLLBACK statement.

Database Objects (25-30%)

1.Demonstrate usage of DB2 data types.
2.Given a situation, show how tablespaces are used.
3.Identify default DB2 tablespaces.
4.Identify default DB2 bufferpools.
5.Identify location/relation of database objects.
6.Given a situation, create tables.
7.Given a situation, identify when referential constraints can be used.
8.Identify methods of data validation.
9.Identify and explain how DB2 logs are used.
10.Identify and explain how system catalogs are used.
11.Identify the characteristics of a view.
12.Identify the characteristics of an index.
13.Identify the characteristics of a database package.

Database Concurrency (5-10%)

1.Identify factors that influence locking.
2.List the objects that locks can be obtained on.
3.Identify the scope of different types of DB2 locks.
4.Identify factors affecting amount of locks that are used.
5.Differentiate the isolation level locking semantics.
6.Given a situation, identify the isolation level.

<图片:  IBM Home Page ><图片:  Support ><图片:  Contact IBM ><图片:  Employment ><图片:  Privacy ><图片:  Legal >?1998 IBM Corporation<图片: IBM Software><图片: Find><图片: Software Home><图片: Data Management Home>

Test Objectives for Test #504 - DB2 UDB V5 Database Administration

DB2 Server Management (15-20%)

1.Manage DB2 instances (authentication, scope).
2.Manage DB2 groups and users.
3.Differentiate database security levels.
4.Describe the use of the SYSADM, SYSCTRL, SYSMAINT authority level.
5.Set user/group access to DB objects using GRANT/REVOKE.
6.Force users/applications off of DB2.
7.Identify characteristics of fenced and not fenced resources.
8.Explain how to setup a Server to support various client protocols.
9.Explain how intra-query parallelism is handled by DB2.
10.Explain the parameters affecting parallelism.

Data Placement (10-15%)

1.Create a database.
2.Discuss the use of Schemas.
3.Differentiate between DMS and SMS Tablespaces
4.Alter Tablespace characteristics.
5.Explain how to determine tablespace pending states.

Database access (10-15%)

1.Bind applications to the database.
2.Create indexes on tables.
3.Create constraints on tables.
4.Create views on tables.
5.Set table check constraints.
6.Set referential constraints.
7.Examining the contents of the System Catalog tables

Monitoring DB2 Activity (20-25%)

1.Obtain/modify database manager configuration information.
2.Obtain/modify database configuration information.
3.Explain how database BUFFERPOOLs are used.
4.Capture EXPLAIN information.
5.Analyze EXPLAIN information. (sortheap, buffpage, degree)
6.Capture database monitor snapshots.
7.Analyze database monitor snapshot information.
8.Explain the aslheapsz parameter.
9.Explain how sorting is performed and how to set the sheapthres parameter.
10.Explain/modify the dir_cache parameter.
11.Explain Differences between monitor types.
12.Identify factors influencing network activity for DB2.

DB2 Utilities (10-15%)

1.Use EXPORT utility to extract data from a table.
2.Use IMPORT utility to insert data into a table.
3.Identify when to use different export file formats.
4.Use the LOAD utility to insert data into a table.
5.Identify when to use IMPORT vs. LOAD.
6.Using the REORG and RUNSTATS utilities.

Database Recovery (10-15%)

1.Perform a database-level BACKUP.
2.Perform a database-level RESTORE.
3.Utilize archival logging.
4.Utilize circular logging.
5.Perform ROLLFORWARD recovery.
6.Examine contents of Recovery history
7.Tablespace-level recovery

Problem Determination (5-10%)

1.Analyze the contents of the SQLCA data structure.
2.Modify deadlock checking interval.
3.Determine applications which are causing concurrency problems.
4.Interpret basic information in the DB2DIAG.LOG file.

----------------------------------------------------------------------
    The end of 503 and 504 obj
----------------------------------------------------------------------

<图片:  IBM Home Page ><图片:  Support ><图片:  Contact IBM ><图片:  Employment ><图片:  Privacy ><图片:  Legal >?1998 IBM Corporation<图片: IBM Software><图片: Find><图片: Software Home><图片: Data Management Home>

Test Objectives for Test #505 - DB2 UDB V5 Application Development

Database Objects (10-15%)

1.Understanding naming conventions of DB2 objects (Aliases, views, etc) 2.Examining packages. 3.Understanding authorities needed to access data in an application. 4.Locating database objects from the system tables

Data Manipulation (20-25%)

1.Querying data across multiple tables. 2.Changing data. 3.Utilize DB2 SQL functions. 4.Utilize common table expressions. 5.Identify when to use cursors in SQL program. 6.Identify Types of cursors. 7.Identify Scope of cursors. 8.Manipulating cursors.
9.Managing a unit-of-work.

DB2 Programming Methods (5-10%)

1.Identify differences between dynamic and static embedded sql. 2.Determine when to use CLI/ODBC.

Embedded SQL Programming (25-30%)

1.Identify steps involved in creating a static embedded sql program. 2.Identify the output of the precompile phase of development. 3.Identify the output of the bind phase of development. 4.Identify when host variables are used (begin-declare).
5.Declaring host variables. 6.Utilizing host variables in queries. 7.Identify characteristics of DB2 programs written in C. 8.Identify characteristics of DB2 programs written in COBOL. 9.Explain/analyze content of SQLCA. 10.Precompile database programs
(.sqc, .c, etc) 11.BIND database programs (Common errors, tables exist). 12.Modify isolation levels at the program level.

Advanced Programming (25-30%)

1.Utilize dynamic SQL within programs. 2.Use the PREPARE statement within dynamic SQL. 3.Use the DESCRIBE statement within dynamic SQL. 4.How signal handlers are used with DB2. 5.Utilize RI within a program. 6.Explain/analyze content of SQLDA.
7.Embedding application logic in DB2 (Constraints, Triggers, Views). 8.Casting UDT's within a program. 9.Identify usage of UDF's. 10.Identify when to use stored procedures. 11.Identify when to use compound SQL. 12.Connecting to databases within an
application. 13.Concurrency considerations within an application.

Application Tuning (5-10%)

1.Obtain database configuration information. 2.Use EXPLAIN facility to modify statements. 3.Analyze EXPLAIN information

<图片:  IBM Home Page ><图片:  Support ><图片:  Contact IBM ><图片:  Employment ><图片:  Privacy ><图片:  Legal >?1998 IBM Corporation<图片: IBM Software><图片: Find><图片: Software Home><图片: Data Management Home>

Test Objectives for Test #506 - DB2 UDB V5 Clusters

DB2 Cluster Concepts (15-20%)

1.Identify the components of the DB2 Universal Database Server 2.Product (given a set of requirements) 3.Estimate the size of the database objects 4.Estimate the number of nodes required (given a set of requirements) 5.Decide the best location for the
data to reside 6.Identify any prerequisite communication products for DB2 for Clusters 7.Use the Command Line Processor 8.Estimate the number of required coordinator nodes based on a set of requirements 9.Distribute users among the DB2 Nodes to
distribute Coordinator function

DB2 Cluster Installation and Configuration (5-10%)

1.Create/maintain node configuration file (db2nodes.cfg) 2.Determine nodegroup requirements

DB2 Cluster Administration Tasks (15-25%)

1.Create a database 2.Create nodegroups 3.Add nodes to an existing database system 4.Execute commands to update data on all nodes simultaneously 5.Redistribute nodegroups 6.Use the split utility to segment the load data 7.Use the Load utility to load
data 8.Create Indexes 9.Gather table statistics 10.Gather index statistics

DB2 Cluster Performance Tuning Tasks (40-50%)

1.Obtain database manager configuration information 2.Modify key database manager configuration parameters 3.Obtain database configuration information 4.Modify key database configuration parameters 5.Create database bufferpool(s) 6.Modify bufferpool
sizes 7.Decide the best method of distributing the data 8.Determine the partition key for a given table 9.Define the partitioning key 10.Reorganize table data 11.Set database monitor switches 12.Analyze database monitor information 13.Collect explain
information 14.Interpret explain output, including various join methods 15.Use explain to identify poorly written SQL queries within an application

DB2 Cluster Application Considerations (10-15%)

1.Create database objects (ie: tables, indexes, etc.) 2.Disable logging during initial object creation 3.Examine system catalog information (to do what) 4.Use the DB2 governer to limit database resources 5.Use the CURRENT NODE register to direct SQL
queries 6.Run applications on each node independantly using the WHERE NODENUMBER function

<图片:  IBM Home Page ><图片:  Support ><图片:  Contact IBM ><图片:  Employment ><图片:  Privacy ><图片:  Legal >?1998 IBM Corporation<图片: IBM Software><图片: Find><图片: Software Home><图片: Data Management Home>

Test Objectives for Test #507 - DB2 UDB V5 DRDA

?

DRDA Concepts (50-60%)

1.Install and configure DB2 Connect 2.Configure the DRDA Application Server capability of DB2 Universal Database 3.Catalog host databases 4.Modify the drda_heap parameter to enable record blocking 5.Setup database instance authentication (client,
server, dcs) 6.Setup SNA authentication types (program, same, none) 7.Utilize the ddcsbind utility 8.Use the various DRDA bind options 9.Configure and utilize DRDA databases in a Distributed Unit of work (DUOW) transaction 10.Configure database
connections using DB2 Connect to DB2 for OS/390 11.Configure database connections using DB2 Connect to DB2 for AS/400 12.Configure database connections using DB2 Connectto DB2 Server for VSE/VM 13.Obtain ddcstrc output 14.Obtain a list of dcs
applications 15.Force users

Setup APPC Communications for DB2 Connect & DRDA(25-30%)

1.Setup a dependant LU (PU2.0) 2.Setup an independent LU (PU2.1) 3.Use NCP and communications controllers 4.Reference VTAM mode definitions and local mode definitions 5.Identify terms PUNAME, IDBLK, IDNUM, TIC, LU name, NETID 6.Setup an APPC
Transaction program TP 7.Configure RU size, pacing and negotiation within SNA mode definitions 8.Setup SNA profiles using SNA Server on AIX 9.Setup Communications Server for APPC connections

Alternative DB2 Connect/DRDA Communication Protocols (15-20%)

1.Identify System Requirements for DRDA AS support over TCP/IP 2.Identify security limitations imposed with DRDA AS support over TCP/IP 3.Configure TCPIP communication with DB2 Connect 4.Identify System Requirements for DRDA AR support over TCP/IP
5.Configure TCPIP communication for DRDA AR support 6.Identify the limits of DRDA AS support over TCPIP 7.Install the Integrated SNA Support 8.Configure the Integrated SNA support for communications

<图片:  IBM Home Page ><图片:  Support ><图片:  Contact IBM ><图片:  Employment ><图片:  Privacy ><图片:  Legal >?1998 IBM Corporation
--      朋友一生一起走
那些日子不再有      一句话  一辈子  一生情  一杯酒      朋友不曾孤单过  一声朋友你会懂      还有伤  还有痛  还要走  还有我

※ 修改:．superman 于 Sep 20 16:49:28 修改本文．[FROM: lilac.hit.edu.cn]
※ 来源:．紫丁香 bbs.hit.edu.cn．[FROM: lilac.hit.edu.cn]

Database 版 (精华区)