RHLinux-DB2 V8.2.

I am trying to setup a database and a table where I can monitor the database growth on a weekly/monthly bases on a production server. I want to run a query and insert the database size for individual databases into a table on weekly/monthly bases.

The result of db2 "call get_dbsize_info(?,?,?,-1)" does not help since I can not insert it into a table. Also, we don't use federated server.

Anyone has a query that will give me the database size I can insert it into a table on weekly/monthly bases ?

Thanks.

Here's a shell script snippet that extracts the get_dbsize_info results as a single line of space-delimited fields. I'm sure you can derive an insert statement from that:

Thanks but it looks like it is using a pearl code which I am not familiar with. I don't think the server is setup to execute a pearl code either.

There was that joke about one prominent writer who, when asked about the book he admired the most, responded: "I don't read no stinkin' books. I'm a writer, not a reader!"

That cracked me up.............Forget the database size !!..........Thanks Nick.

It is funny.

MDX. You might try this

db2 "call get_dbsize_info(?,?,?,-1)" | grep -i -p DATABASESIZE | cut -d: -f2

that will give you just two lines. From there discard non numeric values and you are done.

Sorry, I am not as humorous as Nick

Thanks Cougar,
Although I make the same mistake once in a while (Answering to something without reading/knowing ALL the details) I found his example funny.

I ran your statement and got the following.

grep: invalid option -- p
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.


Thanks.

Looks like you might have had two dashes before p. Post your exact statement.

It works for me

db2 "call get_dbsize_info(?,?,?,-1)" | grep -i -p DATABASESIZE | cut -d: -f2


DATABASESIZE
4600775696384

No........I am copying it from your post. Double - is in the error message not in the command executed. Could it be the Linux/DB2 version

Red Hat Enterprise Linux WS release 3 (Taroon Update 9)
DB2 V.8.1 FP14.


Thanks.

hmm, that I do not know. Create a dummy file and run grep command against it with with out "-p" then with it.

Your dummy file should have more then 4 lines with two lines groups separated by the blank line. i.e.

a
b

c
d

then run

grep -i c filename ---> this should give you a one liner that would just show c

then grep -i -c filename ---> this should give you a two liner that would show c and d

it would have to do with unix vs db2 version

grep -i c filename ----> Gives me "c"

grep -i -c filename ----> Server goes to freeze.


db2 "call get_dbsize_info(?,?,?,-1)" | grep -i DATABASESIZE | cut -d: -f2 -----> (Without the -p Gives me only DATABASESIZE )

Sorry, second command should have had -p and not -c

I wonder why your server went into a freeze mode with -c option. All it does is gives you the count, but that is for another time

Try it again with -p on your file

You would still need to resolve the -p issue, but I have found a way to get you a single lie with just what you need

db2 "call get_dbsize_info(?,?,?,-1)" | grep -i -p DATABASESIZE | grep [0-9] | cut -d: -f2

4564020183040

grep -i -p filename ----> Gives me the same below error. Your latest 1 line statement gives the same below error since it has the -p option........Thanks.

grep: invalid option -- p
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.