can I alter a table (e.g. adding a column) when other user is selecting some c

can I alter a table (e.g. adding a column) when other user
is selecting some columns or updating some columns from the
same table?

Question Posted / guest

1 Answers
4908 Views
I also Faced
E-Mail Answers

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating s..

Answer / s

No, Because it requires an EX lock on the DBD to make
alters to the table description.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More DB2 Interview Questions

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

What information can you find in SYSIBM.SYSLINKS table?

1 Answers TCS,

What is reorg in database?

1 Answers

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers

what is load and unload in db2

1 Answers IBM,

What is the reason behind not using select * in embedded sql programs?

0 Answers

What is cascading rollback?

0 Answers

What information is contained in a SYSCOPY entry?

2 Answers

What is the logical entity between plan and Package?

5 Answers

what are stage one indexable predicates?