DB2 11 System Administrator for z/OS: C2090-317

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. USER2

C. USER3

D. USER4

A column mask is defined on TB_A. Which statement runs successfully?

A. SELECT ' FROM TB_A UNION ALL SELECT ' FROM TB_B

B. SELECT ' FROM TB_A INTERSECT SELECT * FROM TB_B

C. SELECT ' FROM TB_A EXCEPT ALL SELECT ' FROM TB_B

D. SELECT'FROM TB A INTERSECT ALL SELECT * FROM TB B

You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause.

Which action will accomplish this?

A. Set subsystem parameter MAXRBLK to 5000.

B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.

C. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).

D. DB2 does not allow for user control of this maximum allocation.