Advice on how to measure query data size while using DB2?

jayashrib223 over 7 years ago

Hi,

In Appian we have 1 MB limit for any DB query result set so how to determine the size of Query Entity result set?
We are using DB2 database and not able to find any way to measure the resultant data size.

Thanks,
Jayashri

Discussion posts and replies are publicly visible

Parents

0 Omkar K over 7 years ago

This link might help you stackoverflow.com/.../sql-finding-the-size-of-query-result
At-least you will get approximate size. If you create a temp table for your appian query and execute command given in the link. Then you will get data size but you will need to consider size of indices if any.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Omkar K over 7 years ago

This link might help you stackoverflow.com/.../sql-finding-the-size-of-query-result
At-least you will get approximate size. If you create a temp table for your appian query and execute command given in the link. Then you will get data size but you will need to consider size of indices if any.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data