Hi group,
I am going through some exercises regarding DB2 Administration and I
found the below:
How many extents are allocated when the following Employee table is
created in the DMS tablespace TBS03?
create table employee
( ID smallint not null,
name varchar(9),
DEPT smallint check (dept between 10 and 100),
job char(5) check (job in ('Sales', 'Mgr', 'Clerk')),
hiredate date,
salary decimal(7,2),
Comm decimal (7,2),
Notes long varchar,
resume blob,
constraint yearsal check (year(hiredate) 1986 or salary 40500)
) in TBS03;
create unique index inx_u_emp on employee (id);
create index inx_emp_01 on employee (name);
The answer is 10 but I did not understand how can somebody calculcate
this?
Is it one extend for each column of the table?
Many thanks in advance
Demetris