Free and Premium IBM C2090-600 Dumps Questions Answers

The routine cannot contain comments.

The routine must return either an integer or a null.

The routine must be cross-compatible with Oracle PL/SQL syntax rules.

The routine cannot contain argument lists or variable arguments (varargs).

The routine must be generated with IBM Database Conversion Workbench (DCW).

You can change the principal standby of the primary without first stopping HADR on the primary.

The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary’s target list.

The PAGESIZE database configuration parameter is set to 32K.

The AUTO_REORG database configurationparameter is set to NO.

The DFT_EXTENT_SZ database configuration parameter is set to 8.

The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

The INTRA_PARALLEL database manager configuration parameter is set to NO.

REORG TABLE sales AND INDEXES ALL;

RUNSTATS ON TABLE sales AND INDEXES ALL;

REORG TABLE sales INPLACE;

REORG INDEXES ALL FOR TABLE sales;

RUNSTATS ON TABLE salesAND INDEXES ALL;

RUNSTATS ON TABLE sales AND INDEXES ALL;

REORGCHK ON TABLE sales;

RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

1

2

3

4

As the db2 instance owner (db2inst1) execute the command:

exportDB2_FMP_COMM_HEAPSZ=256000

Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

As the db2 instance owner (db2inst1) execute the command:

db2set –i DB2_FMP_COMM_HEAPSZ=256000

As the db2 instance owner (db2inst1)execute the command:

db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

DB2memory sets

the db2diag.log file

Monitoring table functions

A set of pre-defined event monitors

REORG TABLE sales INPLACE RESETDICTIONARY

REORG TABLE sales INPLACE REBUILDDICTIONARY

REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

SYSIBM

SYSFUN

SYSCAT

SYSIBMADM