The answer is Locksize = ANY.Unless you are Sure what’s the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically determine what type of locks it should use.
Tweet This Post

4K to 8K
Tweet This Post

NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT.
Tweet This Post

BSDS is a VSAM KSDS.
Tweet This Post

127
Tweet This Post

: BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.
Tweet This Post

In a subquerry, if the outer querry reffers back to the outcome of innerquerry it is called corelated subquerry. That’s why the outer querry is evaluated first unlike an ordinary subquerry
Tweet This Post

join is used to retrive data from different tables using a single sql statement.union is used to combine the results of two or more sql querries.
Tweet This Post

When you use the primary key and only the primary key in the where clause.
Tweet This Post

DSNDB06
Tweet This Post