what is contained in the DB2 node lock file?
A) data base names
B) data base users names
C) license keys
D) server names
Answers were Sorted based on User's Feedback
Answer / stephen sun
Sorry, the right answer is C) license keys.
[1]pwd
/var/ifor
[2]more nodelock
#
5fbee0ee6feb.02.09.15.0f.48.00.00.00
qifx7bndg9b48n7gafpsa "" "8.1"
#[admin_comment] "IBM Toronto Lab" "DB2 Enterprise Server
Ed (Cust)" "2145852000" "0" "1" ""
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / killer
The Answer is C) License keys
Source:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
?topic=/com.ibm.db2.udb.doc/start/t0006749.htm
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / stephen sun
It should be D) Server Names, the NODE lock file means
db2nodes.cfg
| Is This Answer Correct ? | 0 Yes | 9 No |
What is table space in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is the syntax for FETCH in DB2 ?
When Can you be sure that a query will return only one row?
What is isolation level?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
My SQL is not performing well. Describe how will you fine tune it?
What do the initials DDL and DML stand for and what is their meaning?