How to get database size in DB2?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jerry8huang@gmail.com - 30 Oct 2008 07:53 GMT

The DB2 runs on Redhat, and when I entered following command,

$ db2 call GET_DBSIZE_INFO(?,?,?,0)

I got error like this:

-bash: syntax error near unexpected token `('

anyone could advise, thanks in advance.

Reply to this Message

Frederik - 30 Oct 2008 13:04 GMT

On Oct 30, 7:53 am, jerry8hu...@gmail.com wrote:

> The DB2 runs on Redhat, and when I entered following command,
>
[quoted text clipped - 5 lines]
>
> anyone could advise, thanks in advance.

The '(' and ')' characters have a special meaning in Bash. To tell
Bash not to interpret these characters, surround the command by
quotes:

$ db2 "call GET_DBSIZE_INFO(?,?,?,0)"

You might want to read up on the Bash shell a bit...

Kind regards,

Frederik Engelen

Reply to this Message