IBM DB2 11 System Administrator for z/OS - C2090-317 FREE EXAM DUMPS QUESTIONS & ANSWERS

When might image copies be needed in a data mirroring environment during disaster recovery?
Correct Answer: B Vote an answer
You execute the following SQL against the CDB (Communications Database) of your DB2 subsystem:
INSERT INTO SYSIBM.IPNAMES
(UNKNAME.SECURITY_OUT.USERNAMES,IBMREQD.IPADDR) VALUES ('REMOTEDB'. 'P\ 'O'. 'N', *123.34.45.56');
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES ('REMOTEDB', '123.34.45.56', *N');
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES C REMOTEDB', '123.34.45.57', 'N');
INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORD,IBMREQD) VALUES (T, 'USER1'. 'USER2\ ", ,PWD2,1 *N');
INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORDJBMREQD) VALUES ('O', 'USER1'. 'USER3', *', 'PWD3', 'N');
There is no trusted connection to REMOTEDB. USER1 issues a query addressing remote data source REMOTEDB on your DB2 subsystem.
Which authorization id will be used on the remote data source REMOTEDB?
Correct Answer: D Vote an answer
Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?
Correct Answer: B Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Which action should you take to improve the performance of authorization checking for stored procedures or user-defined functions?
Correct Answer: B Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery.
Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces?
Correct Answer: D Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?
Correct Answer: C Vote an answer
0
0
0
10