472,978 Members | 2,109 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > how to find partitioning key of a table

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

How to find partitioning key of a table


I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

Jan 30 '06 #1
2 8747
jorge wrote:
I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

SYSCAT.COLUMNS.PARTKEYSEQ

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 30 '06 #2
Raj
I try the db2look to extract DDL and view the partitioning key ...
Serge Rielau wrote:
jorge wrote:
I have just started working with DB2 Data Partition Feature.. Given a
table
name, how can I find out the partitioning key of that table? Is there a
SYSIBM.*
table that I can look at?

Thanks,
Jorge

SYSCAT.COLUMNS.PARTKEYSEQ

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab


Feb 8 '06 #3
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
SQL stmt to find if table is in load pending state?
by: technocrat | last post by:
How can i find the load state of the table using SQL, i can do "load query table tablename" but i cannot execute this as a sql statement. What i want to do is, i m using a java stored priocedure to...
DB2 Database
4
Easiest Way to Find a Table
by: Mike Charney | last post by:
What is the easiest and simplest way to find out if a table exists in an Access Data Project? (SQL Svr 2000 Standard using MS-Access 2003 for connection.) Mike Charney m charney at dunlap...
Microsoft Access / VBA
0
How can I make mysqld find the table 'mysql.host' on Fedora Core 4?
by: tomzam | last post by:
I'm trying to get mysql working on Fedora Core 4. Actually trying to start the program mysqld without fatal errors. I posted this message first on the linux misc group - but no luck so far. Maybe...
MySQL Database
3
nirmalsingh
how to find unknown table name from databas
by: nirmalsingh | last post by:
i know database name but i couldn't find table names corresponding to the database in query analyzer. help me to solve.....
Microsoft SQL Server
3
How to find cross table values
by: mnms | last post by:
Hi, I've been looking through these pages and the net looking for an answer to my current problem - to no avail. I'm working on an access database, and triggering the on change event on a form I'm...
Visual Basic 4 / 5 / 6
3
SQL to find if table has identity and/or row change timestamp columns
by: Frank Swarbrick | last post by:
How can I fix this so that it doesn't do essentially the same scan twice, but it gives the same results (a single row where IDENTITY_MODIFIER is either 'identityoverride' or '' and...
DB2 Database
3
Patch for KB948110 causing random "Could not find database table ID"errors
by: Larry Leonard | last post by:
Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe 300 lines, heavily commented). It's an...
Microsoft SQL Server
0
How do I find the table dependency information for stored procedures in db2
by: conrad | last post by:
How to find the table dependency information for stored procedures in db2, I want to see which stored proc are link to a table.
DB2 Database
0
In datacom how to find a table name for creted views
by: hari korrapati | last post by:
hi i have created one view in datacom and now i forgot on which table i created.My question is how to find a table name for created view with the help of SQl
DB2 Database
2
Windows 11 and Access Combo Box Issue
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
Microsoft Access / VBA
2
isladogs
Access Europe meeting on Wed 4 Oct - The future of Access
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
Microsoft Access / VBA
0
How to find best mobile app development company in usa
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
Mobile Development
4
NeoPa
Send Current Object to PDF
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
Microsoft Access / VBA
3
NeoPa
VBA Class Basics
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
Microsoft Access / VBA
1
Report value list
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
Microsoft Access / VBA
0
isladogs
Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
Microsoft Access / VBA
3
Finding a record, and then saving a new record after the record has been amended.
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
Microsoft Access / VBA
0
isladogs
Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
Microsoft Access / VBA

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.

BYTES.COM © 2023
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!