IBM DB2 11 DBA for zOS

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?

Which statement regarding triggers is true?

What is a general recommendation for when to rebind?

A statement-level access path hint can be applied to which type of SQL statement?

Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?

You want to determine which objects of your database DB1 are in LPL. What command should be used?

An application receives an 00C90110 reason code. See the following manual explanation of the code. 00C90110Explanation:The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD). The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database. Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team. Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?

The degree of parallelism can vary for the REBUILD INDEX utility. What action should be taken to limit the use of real memory using the REBUILD INDEX utility?

Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?

What keyword establishes the maximum partition size of a partition-by-growth universal table space?