If the following statement is executed: What occurs if user USER2 connects from the IP address 10.10.10.10 where the database is cataloged with SERVER_ENCRYPT?
User USER1 is a member of the SYSADM group for instance INST1 in DB2 9.7. Database DB_1 was just created within INST1 by user USER2. What additional authorities must be directly granted to USER1 in order for USER1 to retain the same privileges they would have had if database DB_1 had been created with DB2 9.5 by USER2?
A DBA sets the AUTO_DEL_REC_OBJ database configuration parameter to ON. When the PRUNE HISTORY command is executed with the AND DELETE option specified, what will occur?
What is the correct setting for the DIAGSIZE database manager configuration parameter to limit the total size of the db2diag.log and .nfy files to 60 MB and use 10 rotating files for db2diag.log and 10 for .nfy?