| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 5038.1 | | M5::LWILCOX | Chocolate in January!! | Tue Feb 18 1997 10:33 | 16 |
| <<< Note 5038.0 by ITVMS1::GTACCHIN "Giovanni Tacchini" >>>
-< RDB$STORAGE_BLR field, format >-
Columns for table RDB$STORAGE_MAP_AREAS:
Column Name Data Type Domain
----------- --------- ------
.
.
RDB$STORAGE_BLR VARBYTE LIST
Subtype: BLR
Segment Length: 512
.
.
What else are you after and why? Maybe there's another answer.
|
| 5038.2 | | ITVMS1::GTACCHIN | Giovanni Tacchini | Tue Feb 18 1997 11:34 | 30 |
| <<< Note 5038.1 by M5::LWILCOX "Chocolate in January!!" >>>
RDB$STORAGE_BLR VARBYTE LIST
Subtype: BLR
Segment Length: 512
This field is used to store information about the horizontal partitiong of
logical area, the column(s) name and upper limit of each partition.
I'm right?
>What else are you after...
really I need the format of segment.
E.G.
byte 1 indicate the number of column in STORE USING(...)
byte 2 indicate the length of the name of column 1
from byte 3 to n the name of column
bla bla
> and why? Maybe there's another answer.
How I can obtain information about horizontal partitioning of logical area
by a query on system relation?
The reason.
I have devolopped a tools to manage physical schema, actually I use RMU/EXTRACT
to obtain info about STORE CLAUSE (create storage map, create index),
NODE SIZE (create index) and THRESHOLDS (mixed storage area, L.A. on uniform,
indexs). I obtain many other parameters by query on system relation.
If possibile I want use only query on system relations.
Thank
GIovanni
|
| 5038.3 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Tue Feb 18 1997 11:38 | 7 |
| RDB$STORAGE_BLR contains a BLR fragment which defines the limits clauses. It
is a complex expression. Use RMU/EXTRACT/OPTION=FULL to see the partition
expression displayed.
THRESHOLDS are not available via the system relations.
Ian
|
| 5038.4 | Thanks | ITVMS1::GTACCHIN | Giovanni Tacchini | Tue Feb 18 1997 11:56 | 10 |
| <<< Note 5038.3 by NOVA::SMITHI "Don't understate or underestimate Rdb!" >>>
>Use RMU/EXTRACT/OPTION=FULL to see the partition expression displayed.
WONDERFUL, now I can understand many things (the "DUMP" of the fragment)!
>THRESHOLDS are not available via the system relations.
:-(
Thanks a lot, ciao
GIovanni
|
| 5038.5 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Tue Feb 18 1997 13:02 | 12 |
| ~>Use RMU/EXTRACT/OPTION=FULL to see the partition expression displayed.
~WONDERFUL, now I can understand many things (the "DUMP" of the fragment)!
It is not a dump exactly but rather an interpretation. To see the BLR
displayed use the /OPTION=DEBUG
~>THRESHOLDS are not available via the system relations.
~:-(
Well in Rdb8 that will change... :-)
Ian
|
| 5038.6 | thank again | ITVMS1::GTACCHIN | Giovanni Tacchini | Tue Feb 18 1997 13:28 | 9 |
| >It is not a dump exactly but rather an interpretation. To see the BLR
>displayed use the /OPTION=DEBUG
RE WONDERFUL
>Well in Rdb8 that will change... :-)
:-)
GIovanni
|