473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

PRIQTY and SECQTY

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.systablepart" statement, but I once executed this statement and found out that that table doesn't exist)
Aug 8 '08 #1
0 2762

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Michal Krawczyk | last post by:
J have tablespace named TSPACE, with table DATA with about 3mln rows. I want to create index named O123TA, but execution ends with error: DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION...
7
by: junk_bucket | last post by:
Apparently the maximum value of SECQTY for all tablespaces at a site I am supporting is 131068 which is a pre version 6.2 maximum. Any insight would be appreciated. Spufi alter and catalogue...
1
by: Richard | last post by:
I have been asked to copy a handfull of table spaces in to new identical table spaces so that they can be accessed with out running into the nightly batch update. I first did a FULLCOPY with...
1
by: rendezvous | last post by:
Hello all, Can you please brief me on how does the pri qty and sec qty which is given during the create tablespace statement affect the tablespace. Will the tablespace once created use the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.