DB2 11 System Administrator for z/OS v6.0

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?

You use utility DSN1PRNT to print the header page of table space DB1TS1.
Where do you find information about the various header page fields?

Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

DB2 can use RUNSTATS profiles for autonomic statistics maintenance.
Which catalog table holds the options specified for the profiles?

What is the minimum level of authority needed to use the DETAIL keyword on a -DISPLAY
THREAD command?

How can conditional restarts affect sequence objects?

Which command can be used to adjust the system checkpoint frequency?

The subsystem parameter PKGREL_COMMIT is set to YES. Which statement is true for packages bound with RELEASE(DEALLOCATE)?

A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work.
What action(s) would provide the best chance to initially attempt to cancel this thread?

The use of the work file database for RID list processing is controlled by the value of which subsystem parameter?

Your production DB2 subsystem is up and running, the following message is received:
DSNJ126I - BSDS ERROR FORCED SINGLE BSDS MODE
because one of the BSDS volumes is offline.
After the volume is back online, in order to ensure a securely running system, what is the least disruptive scenario to correct this error?

What will occur if the parameter PAGE PROTECT is set to YES?

What utility can benefit from the additional zllP (IBM System z Integrated Information
Processor) enablement inDB2 11?

Which statement regarding DSN1LOGP is FALSE?