what is the name of the default db2 catalog database?
Answers were Sorted based on User's Feedback
How connect db2 database to datastage?
When would you prefer to use VARCHAR?
What is a DB2 bind?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Name the various locking levels available?
Mention the downsides of page level lock.
Explain the contents that are a part of dclgen.
Give some example of statistics collected during RUNSTATS?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is dbrm library?
How to resolve -504 sql code in DB2?
What keyword does an SQL SELECT statement use for a string search?