51.
The database sample is created using the following command:
CREATE DATABASE sample ON /database
In order to update statistics for only the tables that need it, between the hours of midnight and 2am, what actions must be taken?
CREATE DATABASE sample ON /database
In order to update statistics for only the tables that need it, between the hours of midnight and 2am, what actions must be taken?
- A.Enable HEALTH MONITOR for the database.
- B.Update the relevant database configuration parameters.
- C.Update the relevant database manager configuration parameters.
- D.Use automatic maintenance and define an appropriate maintenance window.
- Answer
- Report
Answer : [D]
2.
There is a job in Task Center scheduled to run every Saturday. The Scheduler is turned off on Friday for
system maintenance and then restarted on Monday. Under which of the following conditions is the job
scheduled for Saturday executed when the Scheduler is restarted?
- A.The exec_exp_task DB2 registry is set to yes.
- B.The exec_exp_task Database configuration parameter is set to yes.
- C.The exec_exp_task Database Manager configuration parameter is set to yes.
- D.The exec_exp_task Administration server configuration parameter is set to yes.
- Answer
- Report
Answer : [D]
3.
A DBA attempts to use the Task Center to schedule a daily database backup and is not successful. A
GET ADMIN CFG command shows that TOOLSCAT_DB, TOOLSCAT_INST, and TOOLSCAT_SCHEMA
are all NULL on the DB2 server where the backup task was attempted.
What must be done to enable scheduling of tasks on this server using the Task Center?
What must be done to enable scheduling of tasks on this server using the Task Center?
- A.Use the CREATE DATABASE command to create a database called TOOLSDB.
- B.Use the CREATE TOOLS CATALOG command to create the DB2 tools catalog tables in a new or existing database.
- C.Create a table space called SYSTOOLSPACE in the database that the Task Center was trying to schedule a Backup for using CREATE TABLESPACE.
- D.Create a new schema called TOOLSCAT in the database that the Task Center was trying to schedule a Backup for and then use UPDATE ADMIN CFG to reference that database, instance and schema.
- Answer
- Report
Answer : [B]
4.
For a DB2 instance db2inst1 on a server with port 50000 available, which of the following commands
must be run in order to configure DB2 to listen for incoming TCP/IP connections?
A. db2set db2comm=tcpip B. db2set db2comm=tcpip C. db2 UPDATE DBM CFG USING TP_MON_NAME db2inst1 D. db2 UPDATE DBM CFG USING TP_MON_NAME db2inst1 E. Add "DB2c_db2inst1 50000/tcp" to the services file F.db2set db2comm=tcp/ip
- A.a,b,c
- B.c,e,d
- C.a,d,e
- D.a,c,e
- Answer
- Report
Answer : [D]
5.
Given the following server information, which of the following commands will catalog this node?
Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host TCP/IP address: 10.205.15.100
Hostname: tcphost
Protocol : TCP/IP
Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host TCP/IP address: 10.205.15.100
Hostname: tcphost
Protocol : TCP/IP
- A.CATALOG TCPIP NODE db2tcp REMOTE 10.205.15.100
- B.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER 60000
- C.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER db2inst1
- D.CATALOG TCPIP NODE db2tcp REMOTE tcphost INSTANCE db2inst1
- Answer
- Report
Answer : [B]
|
|
||||||||||||||||||||||||||||
