Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase table partitioning information

2 posts in General Discussion Last posting was on 2013-03-19 10:51:44.0Z
Newbiee Posted on 2013-03-19 06:02:37.0Z
Sender: 5405.5147fe6f.1804289383@sybase.com
From: Newbiee
Newsgroups: sybase.public.ase.general
Subject: Sybase table partitioning information
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5147ff7d.5443.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Mar 2013 22:02:37 -0800
X-Trace: forums-1-dub 1363672957 172.20.134.41 (18 Mar 2013 22:02:37 -0800)
X-Original-Trace: 18 Mar 2013 22:02:37 -0800, 172.20.134.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31728
Article PK: 1308457

Hi, I am creating one report for ASE 12. I need to know the
type of partition for each user table. Is there any way by
which I can get the table name and the type of partition?
Is there any system table where I can get this information?

I need this ->
--------------------------
Table name partition type
table1 round robin
table2 other partition
---------------------------
thanks in advance.


Rob V Posted on 2013-03-19 10:51:44.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase table partitioning information
References: <5147ff7d.5443.1681692777@sybase.com>
In-Reply-To: <5147ff7d.5443.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <51484340$1@forums-1-dub>
Date: 19 Mar 2013 02:51:44 -0800
X-Trace: forums-1-dub 1363690304 172.20.134.152 (19 Mar 2013 02:51:44 -0800)
X-Original-Trace: 19 Mar 2013 02:51:44 -0800, vip152.sybase.com
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31729
Article PK: 1308463


On 19-Mar-2013 07:02, Newbiee wrote:
> Hi, I am creating one report for ASE 12. I need to know the
> type of partition for each user table. Is there any way by
> which I can get the table name and the type of partition?
> Is there any system table where I can get this information?
>
> I need this ->
> --------------------------
> Table name partition type
> table1 round robin
> table2 other partition
> ---------------------------
> thanks in advance.
>

Already answered in sybase.public.ase.administration.

******
Please note that these newgroups will go offline soon.
See
http://nntp-archive.sybase.com/nntp-archive/action/article/%3C513726e2%40forums-1-dub%3E
for more details about the new location of the forums
******


--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------