Which action gives you the option to rebind packages with the ability to fall back to the original access path
You are planning the migration of your DB2 subsystem from version 8 to version 9. Rebinding
existing packages is highly recommended, but you are also worrying about potential problems that
might occur with new access paths after rebind. Which action gives you the option to rebind
packages with the ability to fall back to the original access path if performance problems are
encountered?
What should be done to increase the number of allied connections that can be allocated concurrently?
A number of jobs are waiting for an allied connection to access a DB2 subsystem. What should be
done to increase the number of allied connections that can be allocated concurrently?
Which mode describes the DB2 subsystem?
A DB2 subsystem is being migrated/converted from DB2 Version 8 to DB2 9. The subsystem
currently has these characteristics: new DB2 9 functions are not available; no DB2 9 objects can
exist; the subsystem cannot fall-back to CM (conversion mode); the subsystem cannot fall-back to
Version 8; the subsystem cannot coexist with any Version 8 systems in a data sharing group.
Which mode describes the DB2 subsystem?
Which two statements regarding system parameters are true?
Which two statements regarding system parameters are true? (Choose two.)
Which two methods can be used to configure the use of a SSL secure port on a DB2 for z/OS server?
Which two methods can be used to configure the use of a SSL secure port on a DB2 for z/OS
server? (Choose two.)
Which two actions can they take to reduce this contention?
In a data sharing system, a system programmer observes very high page p-lock contention.
Which two actions can they take to reduce this contention? (Choose two.)
Which three could contribute to the class 3 times?
An accounting report shows high class 3 times. Which three could contribute to the class 3 times?
(Choose three.)
which two for execution?
The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires which two
for execution? (Choose two.)
Which action should be performed to only use the system level backup that was taken to disk?
A customer has just migrated their DB2 system to V9 new function mode. They currently use the
BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action should be
performed to only use the system level backup that was taken to disk?
Which action should be performed to correct the CRCR record?
A customer is performing a traditional image copy disaster recovery test. The systems
programmer creates a conditional restart control record (CRCR) but detects an error before
starting DB2. Which action should be performed to correct the CRCR record?