Online Access Free C2090-317 Practice Test

In order to guarantee complete security for your DB2 subsystem, which statement is correct?

• A.BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege
• B.BSDS and catalog VSAM data sets should always be protected by the MSTR address space.
• C.BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.
• D.BSDS and catalog VSAM data sets should always be protected by an external security profile.

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?

• A.USER1
• B.USER3
• C.USER2
• D.USER4

The -ALTER UTILITY command changes the values of certain parameters of a utility.
Which two utilities can this command be issued against?

• A.RECOVER
• B.REBUILD
• C.REORG
• D.COPY
• E.MODIFY

A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.
What is the recommended way to resolve this problem?

• A.Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
• B.Restart the failed DB2 member with the LIGHT(YES) option.
• C.-START DB(DBA) SP(TSA) ACCESS(FORCE)
• D.Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname

Which action should you take to improve the performance of authorization checking for stored procedures or user-defined functions?

• A.Increase the value of subsystem parameter AUTHCACH.
• B.Increase the value of subsystem parameter CACHERAC.
• C.Set subsystem parameter EXTSEC to YES.
• D.Increase the value of subsystem parameter SECQTY.