Connecting Tech Pros Worldwide Help | Site Map

How to get database size in DB2?

  #1  
Old October 30th, 2008, 07:55 AM
jerry8huang@gmail.com
Guest
 
Posts: n/a
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.
  #2  
Old October 30th, 2008, 01:05 PM
Frederik
Guest
 
Posts: n/a

re: How to get database size in DB2?


On Oct 30, 7:53*am, jerry8hu...@gmail.com wrote:
Quote:
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.
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
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Max table or database size? shawno answers 6 November 16th, 2008 05:35 AM
CHAR to VARCHAR conversion in DB2(iSeries) maheshmohta insights 0 January 16th, 2008 10:19 AM
How to collect DB2 Database size Version Lesser than 8.2 vijay.db@gmail.com answers 4 April 20th, 2007 08:05 PM
Advice sought on best way to get data into a Linux db2 8.1.4 database Alex answers 3 November 12th, 2005 06:04 AM