#12550: Table storage properties are not reflected in storage tab of ER- Modeler.

nileshhmali reported 2014-10-13T13:17:36Z · last modified 2014-11-04T00:42:58Z

Table storage properties are not reflected in storage tab of ER- Modeler.

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	16.0

ADS Version:ADS-15.0.7-31

Connect Teradata-15.0

//Create table

CREATE SET TABLE "Test_table" ,

FALLBACK,

LOG,

NO BEFORE JOURNAL,

DUAL AFTER JOURNAL,

WITH JOURNAL TABLE = "sqlscript"."journals",

FREESPACE = 20 PERCENT,

MERGEBLOCKRATIO = 1 PERCENT,

DATABLOCKSIZE = 21504 BYTES,

BLOCKCOMPRESSION = MANUAL,

CHECKSUM = DEFAULT (

"col1" VARCHAR(25) CHARACTER SET LATIN,

"col2" VARCHAR(25) CHARACTER SET LATIN,

"col3" VARCHAR(25) CHARACTER SET LATIN

)

Go to right click on table ->tools->ER modeler generator

check tables from object type

Check table "dbo"."Test_table" from object.

Check

click on next button.

Entity relationship diagram open

Now go to this window->right click on table->select table properties->switch to storage tab.

Now you will observe that,Free space,Merge Block Ratio,Data Lock Size,Block Compression properties are not reflected in storage tab of ER- Modeler.

1 attachment

ER.png

2014-10-13T13:17:36Z

393 KB

All Comments (1) Change History

tariqrahiman 2014-11-04T00:42:58Z

Fixed with 12600

Search Tips

Aqua Data Studio / nhilam

Table storage properties are not reflected in storage tab of ER- Modeler.

1 attachment

Issue #12550

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Table storage properties are not reflected in storage tab of ER- Modeler.

1 attachment

Issue #12550

Completion