Hy everyone, I'm totally new in DB2 and currently doing some study concerning tablespace setting parameter and having some doubts in PRIQTY and SECQTY. Actually what are they ? What're their functions ? And what change would it make if I change their values ?
I found out that they could only be used only if storage group is used also. When a storage group is created, if the PRIQTY and SECQTY's values aren't specified, DB2 will use their defaut values. But, what is their default values ? (I found that I supposed to be able to view their values by using "select priqty,secqty from sysibm.systable part" statement, but I once executed this statement and found out that that table doesn't exist)
I found out that they could only be used only if storage group is used also. When a storage group is created, if the PRIQTY and SECQTY's values aren't specified, DB2 will use their defaut values. But, what is their default values ? (I found that I supposed to be able to view their values by using "select priqty,secqty from sysibm.systable part" statement, but I once executed this statement and found out that that table doesn't exist)