Which authority is required for the creation of a database role?
Which authority is required for the creation of a database role?
Which two statements are correct in DB2 9?
Which two statements are correct in DB2 9? (Choose two.)
Which system parameter would be used to help implement the IT standard?
A DB2 subsystem is set up to take a checkpoint every two minutes. Applications that use this DB2
subsystem are supposed to adhere to an IT standard where a commit should be issued by the
application at least every 200 SQL changes (INSERTs, UPDATES, or DELETEs). Which system
parameter would be used to help implement the IT standard?
What is the reason for this happening?
You are migrating your DB2 for z/OS subsystem to version 9 NFM. As part of the migration
process, you intend to step through the different IBM provided IVP phases to verify that everything
is working well. Looking at the generated jobs, you recognize that there is only one job that has
been created for phase 6 (accessing data at a remote site) rather than the whole set of jobs. What
is the reason for this happening?
Which case would require you to perform a DB2 conditional restart?
Which case would require you to perform a DB2 conditional restart?
which facility will function incorrectly?
When implementing the DB2 for z/OS built-in encryption function, which facility will function
incorrectly?
Which statement is true?
An index, originally defined with COPY YES and in buffer pool BP8K0, is altered to a compressed
index and rebuilt. Which statement is true?
which SMF record type?
DB2 audit class trace records are externalized to which SMF record type?
Which statement is true?
All members of a data sharing group can be accessed by the group attachment name GRP. Two
members (DB2A and DB2B) of the data sharing group are up on the same z/OS and you run a
batch job on this z/OS with the following DSN command: DSN SYSTEM(GRP). Which statement
is true?
which authorization ID setting will be ensured?
Using the sample IBM supplied authorization exit, which authorization ID setting will be ensured?