×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS
samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS
samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?
2.
Table T1 was created by executing the following statement:
Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1.
The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current
statics exist for the table and index, which index will provide optimal performance for this query?
Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1.
The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current
statics exist for the table and index, which index will provide optimal performance for this query?
3.
Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?
4.
Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?
5.
Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information:
DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64. Which setting would optimize I/O for the largest table?
DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64. Which setting would optimize I/O for the largest table?
6.
What determines the degree of inter-partition parallelism used?
7.
Which statement about compression and temporary tables is NOT correct?
8.
A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?
9.
Which command will prevent prefetching during crash recovery?
10.
What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?