How to calculate size of partition in DB2

Hi,

I need to find out the the total size of a partition and how much of it has been utilized.

How to calculate the percentage of utilization of a partition in DB2 of Z/OS.

Thanks

Oct 16 '09 #1

Subscribe Post Reply

6262

lowpaydba

Hi,

DB2 LUW has the get_dbsize_info(?, ?, ?, 0) stored procedure to calculate the size of the databases. I'm not sure if this procedure is available in z/OS, but you may want to verify this.

Also this general approach may be useful.

use db2_all command (not sure its available in z/OS!) to list the table space container info for the database in question.

db2_all "list tablespace containers for <tablespacenum> show detail"

This will dump out

1. the path to the containers (in case of SMS tablespaces it will be a directory for DMS it will be a file or raw device).
2. Total number of pages used
3. Total number of useable pages.

Under Unix the size of the file in (1.) can be measured using the du command. I'm guessing Z/OS has a similar utility/command?

Oct 30 '09 #2

Similar topics

maximum size of a database/tablespace

by: Kums | last post by:

What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.

DB2 Database

K&R chapter 6.3 Question 'how to calculate the number of array elements'

by: Herrcho | last post by:

in K&R Chapter 6.3 it mentions two methods to calculate NKEYS. and points out the first one which is to terminate the list of initializers with a null pointer, then loop along keytab until the...

C / C++

How to calculate the stack and heap size

by: ivan | last post by:

Hi, How can we calculate the stack and heap size requried by a C program. Is there any specific formula used? Please suggest. regards, Ivan

C / C++

Creating a new partition in an OLAP database

by: Mark Dengler | last post by:

I am trying to write a C# backend program that will handle the database maintenance that I would otherwise have to do via Microsoft's Analysis Services front end GUI Wizards. Currently I am having...

C# / C Sharp

table size/record limit

by: Dennis Gearon | last post by:

I am designing something that may be the size of yahoo, google, ebay, etc. Just ONE many to many table could possibly have the following characteristics: 3,600,000,000 records each record is...

PostgreSQL Database

Option Strict On

by: Vijay | last post by:

With the option strict On set..... Dim fs As FileStream = File.OpenRead(strFile) With fs Dim buffer(fs.Length) As Byte ' <--- Option Strict On disallows implicit conversions from 'Long' to...

Visual Basic .NET

Calculate length of input based on parent <TD>

by: Michael | last post by:

Hi. I need dinamically calculate input text field based on parent static TD before showing content of input. Please, advice. Michael

ASP / Active Server Pages

Increase Partition Size

by: sandeepmanocha | last post by:

Hi Everyone, I am working in a MNC as Database Developer.I am facing a problem. I am working on Oracle 9i database, on HP Unix Platform. The tablespaces we created are mounted on HDD say...

Linux

Using Partition -2

by: debasisdas | last post by:

SAMPLE CODE TO CREATE SUB PARTITIONS ======================================= RANGE-HASH-9i ------------------------- CREATE TABLE SUBPART ( ID NUMBER(10) PRIMARY KEY, NAME VARCHAR2(20) )

Oracle Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware