Which of the following commands is required to update the local node directory so that a DB2 client can access
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP
address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the
following commands is required to update the local node directory so that a DB2 client can access
this DRDA database?
Which response would indicate to the administrator that they should choose SMT2 instead of SMT4?
An administrator is asked to configure an LPARfor a new application. The administrator
inquires about the nature of the application to be hosted on the LPAR in order to better
understand how the LPAR should be configured. Which response would indicate to the
administrator that they should choose SMT2 instead of SMT4?
which of the following is true?
Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5
ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the
following is true?
Which of the following statements correctly summarizes this situation?
An administrator is trying to configure NPIV on a new VIO Server partition. When running the
Isnports command the following is displayed:
Which of the following statements correctly summarizes this situation?
which of the following events will the most recently generated value of MY_SEQ persist so that it can be retur
Within the application MY_APP the following PREVIOUS VALUE expression references the
sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq
After which of the following events will the most recently generated value of MY_SEQ persist so
that it can be returned to the active MY_APP application?
What is the most likely cause of the problem?
An administrator has started to configure a new Power 770. After installing the first partition
with AIX 5.3 TL11 using dedicated processors the administrator notices that AIX defines only
2 threads per core. The administrator was expecting to see 4 threads per core. What is the
most likely cause of the problem?
which of the following purposes?
A declared temporary table is used for which of the following purposes?
Which list command will give the required information?
An administrator noticed on an LPAR running AIX that several recoverable errors have been
logged, involving hdisk6. The administrator has talked to IBM support and a replacement
drive is being sent. When the disk arrives, it will be hot swapped. The administrator needs to
find out what logical volumes may have data stored on this particular drive so that any
necessary action can be taken. Which list command will give the required information?
Which of the following DB2 objects is NOT considered executable using SQL?
Which of the following DB2 objects is NOT considered executable using SQL?
Which problem can arise during normal use of the cluster?
A customer implemented a PowerHA System Mirror cluster for their database. The cluster is
used simultaneously by many clients during work hours. For the non-IP heartbeat network,
they decided to use the same LUN as for the data files. Which problem can arise during
normal use of the cluster?