473,386 Members | 1,644 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,386 software developers and data experts.

DBA question on locating partition to which a specific tablespace page exists

I am a DBA on DB2 Z/os V8 NFM. I am seeing the error listed below in the DB2 master. This type of error has been seen previously. in an attempt to reduce / eliminate the error the decision was made to increase the PCTFREE and add FREEPAGE to the tablespace. The partitions have been altered for these settings. The table is inserted to in high order sequence based on an identity key field. Based on that information the highest 20 parts used were reorged this past weekend. Updates may occur in prior parts. What I am trying to determine is the partition associated to the page number given in the error message. This will help me to determine if the page is in one of the parts reorged and upgraded, one of the older parts not yet upgraded, or finally if it has rolled to the next empty part, that has not yet been upgraded (currrently my assumption). I really appreciate any information that would help in this determination.

06.07.31 STC51645 DSNT375I -DBP3 PLAN=DISTSERV WITH 916
916 CORRELATION-ID=DataFlowEngi
916 CONNECTION-ID=SERVER
916 LUW-ID=GA21502C.OAAC.081104110658=55121
916 THREAD-INFO=GSB3APP#:wdc4119a:gsb3app#:DataFlowEngine
916 IS DEADLOCKED WITH PLAN=DISTSERV WITH
916 CORRELATION-ID=DataFlowEngi
916 CONNECTION-ID=SERVER
916 LUW-ID=GA21502B.O8B2.081104095004=37344
916 THREAD-INFO=GSB3APP#:wdc5132a:gsb3app#:DataFlowEngine
916 ON MEMBER DBP1
06.07.31 STC51645 DSNT501I -DBP3 DSNILMCL RESOURCE UNAVAILABLE 917
917 CORRELATION-ID=DataFlowEngi
917 CONNECTION-ID=SERVER
917 LUW-ID=GA21502C.OAAC.081104110658=365505
917 REASON 00C90088
917 TYPE 00000302
917 NAME GB3A3001.PSCLTX .X'2A03EEE7'

Digger61
Nov 4 '08 #1
0 1885

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

Similar topics

41
by: Xah Lee | last post by:
here's another interesting algorithmic exercise, again from part of a larger program in the previous series. Here's the original Perl documentation: =pod merge($pairings) takes a list of...
5
by: BBands | last post by:
I'd like to see if a string exists, even approximately, in another. For example if "black" exists in "blakbird" or if "beatles" exists in "beatlemania". The application is to look though a long...
7
by: Gladiator | last post by:
Hai all, I have Db2 installed in a partition environment . There are 4 partitons on which i created the instance. can any one tell me if i can create a database on the required partitons .........
1
by: saidev | last post by:
Hi Team, I have been getting error message for creating tablespace on the multiple logical partition database on single aix machine for tools catalog database. I did try with sevaral other paths...
0
by: Vinod Sadanandan | last post by:
Table Partition Performance analysis ============================================ Collection of Statistics for Cost-Based Optimization/DBMS_STATS vs. ANALYZE The cost-based approach relies on...
0
by: bradleycalcagni | last post by:
Am attempting to develop a scheduled process to check table partitions and add new date-based partitions (split maxval partition) when needed (based on a table of partitioning rules). What good...
0
by: sandeepmanocha | last post by:
Hi Everyone, I am working in a MNC as Database Developer.I am facing a problem. I am working on Oracle 9i database, on HP Unix Platform. The tablespaces we created are mounted on HDD say...
3
by: Justin | last post by:
What is the syntax to overlap partitions? Lets assume I want a year split amount 4 months (3 partitions for a year) and later adding an additional set of partitions for every 6 months. Plus...
3
by: Justin | last post by:
Is there a way to attach a partition to an existing table that already has partitions (without loading data)? For example, the syntax of the attach partition is documented below: alter table...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.