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
4858 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

what's the best lock size that you could use when you create a tablespace?

2 Answers IBM,

Explain about rct.

0 Answers

i have a db2 variable how do u declare tht into working storage section ?

1 Answers TCS,

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers RBS,

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers

how we will do null data selection in cobol-db2 program

2 Answers Wipro,

What is difference between rollback and commit?

0 Answers

can we drop column from a table

7 Answers INDUS,

What is a dbrm in db2?

0 Answers

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers IBM,

Discuss about db2 bind?

0 Answers

For more DB2 Interview Questions Click Here