IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Database, Tablespace and Table size estimation


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Fri Aug 15, 2008 2:03 am
Reply with quote

Hi all,

I have to create a table in test region, but dont have privileges to create in a default database. so I am trying to create in another database, here i would like to know how to estimate the how much space is left free in the database and tablespace.


Could any one please help me in this regard.

Thanks in advance.

*** If my question is not appropriate pls excuse me ***
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Aug 15, 2008 2:23 am
Reply with quote

Hello,

Before you "borrow" space from "another database" i suggest you talk with the dba(s) and ask where you should locate your new entities.

They will set up permissions and possibly a new database/tablespace if you are supposed to do this.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Fri Aug 15, 2008 4:53 am
Reply with quote

Thanks dick scherrer
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Aug 15, 2008 5:03 am
Reply with quote

You're welcome - good luck icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts What database does Jobtrac use CA Products 4
Search our Forums:

Back to Top