| View previous topic :: View next topic |
| Author |
Message |
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
 Posted: Mon Sep 22, 2008 12:04 pm Post subject: Database size calculation |
 |
|
Hi all,
As I have never done this database size calulation i would like to request you all to pls suggest me.
Thanks in advance to all.
Could anyone please let me know how to calculate the size of the database for the following ddl.
| Code: |
CREATE TABLE "TOYOTASH"."TSHOPER"
( "RID" DECIMAL(11, 0) NOT NULL
,"OPSEQ" SMALLINT NOT NULL
,"OPCODE" CHAR(10) NOT NULL
,"OPCOMB" CHAR(1) NOT NULL
,"OPHOURS" DECIMAL(5,1) NOT NULL
,"OPTECHID" INTEGER NOT NULL
, "CREATEDBY" CHAR(8) NOT NULL
, DATEOFCREATION TIMESTAMP NOT NULL
, LASTUPDATEDBY CHAR(8) NOT NULL
,UPDATEDTMSTMP TIMESTAMP NOT NULL
,"OPDESC" CHAR(4000) NOT NULL
)
IN "DBLCST5"."TSHOPER" |
_________________
Satya |
|
| Back to top |
|
 |
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Mon Sep 22, 2008 2:44 pm Post subject: |
|
|
How many rows?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
pcsingh_2000
Beginner
Joined: 13 May 2003
Posts: 15
Topics: 6
Location: Kolkata
|
| Posted: Fri Nov 07, 2008 7:07 am Post subject: |
|
|
Hi,
Are you asking size of DBLCST5 database. If, yes.. run the STOSPACE utility on the storage group, this database is using. This will update Space column in sysibm.sysindexes and sysibm.tablespace. After that you can easily run a query to sum up all tablepace/indexspaces for this database.
Cheers..
_________________
prakash c. singh
voice:00-91-93315 16675 |
|
| Back to top |
|
|
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
| Posted: Thu Nov 20, 2008 3:22 pm Post subject: |
|
|
Thanks all for your suggestions.
_________________
Satya |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
