How can I PACK table attribute???

[Former Member]

I read that:

"The PACKED table attribute causes integer values to be compressed and

stored and as a result, they require less memory space on the volumes.

The results in a faster I/O access and reduced displacement in the

data cache."

Note 1040431 - FAQ: MaxDB BW Feature Pack

But I don"t know how to do this!!!! could someone help me!??

[Former Member · Accepted solution]

ok, I can pack tables in BW. so there is another question: can I just PACK SQL table or not? is it possible? when i am trying to write some kind of code like this (alter table <name of table> packed ) in SQL studio it returns me

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

General error;-8062 POS(1) Table cannot be packed

alter table DDNTF packed

[Former Member · Accepted solution]

Hi Dennis,

the syntax you were using is correct, but there is a restiction - all non key columns of the table have to be columns with type INT.

Did you checked the Refernce Manual in MaxDB documentation on

[maxdb.sap.com|http://maxdb.sap.com]? Can you find any more information there?

Regards, Christiane Hienger

[Former Member]

Yes, I check, but I'll check it one more time! thanks for your help!

[Former Member]

HI!

I am trying to pack my tables, but I don"t realy know how to do this! )

my MaxDb version is 7.06.04.15 and I am running a SAP BI system with the MaxDB database.

I check note but I can only see information about what is it PACKED tables and how can see what table is PACKED.

Sorry, for my english. do you speak russian? )))

[Former Member]

Hello Dennis,

there is a SAP-Reports which clusters and packs all Fact-Table sin your Bi-System.

Please use the following link to get more detailed information:

[BW Feature Pack|https://wiki.sdn.sap.com/wiki/x/W0o]

and the how to (point 6) [HowTO BI-Feature Pack|https://wiki.sdn.sap.com/wiki/x/hx0B]

If you need additional help don't hesitate to open a custoerm call in the SAP Support-System OSS on component BW-SYS-DB-SDB.

Regards, Christiane

[former_member229109]

Hello Denis,

You posted the answer on the question "What effect does the PACKED table attribute have?" from the SAP Note 1040431.

-> Did you check another questions/answers from this note?

"But I don't know how to do this!!!! could someone help me!??"

=> Could you please be more specific.

• What are you going to do?

• What is the version of the MAXDB on your system?

• Are you running a SAP BI system with the MaxDB database?

Thank you and best regards, Natalia Khlopina