473,461 Members | 1,521 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DDL statements of Tablespaces and Bufferpools

Hi,

Am trying to create the DDL statements of a database using
$ db2look -d TESTDB -e -z db2tar -i testiii -w test123 -m -o
db2look.sql

I get all the useful information except that of the Bufferpools and
Tablespaces....
Is there any other alternative to get the DDL of the bufferpools and
Tablespaces ??

There are around 100's of tablespaces and bufferpools with varying
sizes and definitions..
Any option how to get the DDL's

Thanks in advance.....

Sep 1 '06 #1
2 6769
In article <11**********************@m79g2000cwm.googlegroups .com>,
ta**********@gmail.com says...
Hi,

Am trying to create the DDL statements of a database using
$ db2look -d TESTDB -e -z db2tar -i testiii -w test123 -m -o
db2look.sql

I get all the useful information except that of the Bufferpools and
Tablespaces....
Is there any other alternative to get the DDL of the bufferpools and
Tablespaces ??

There are around 100's of tablespaces and bufferpools with varying
sizes and definitions..
Any option how to get the DDL's

Thanks in advance.....

You can use the -l option for that. Copied from the docs:

If this option is specified, then the db2look utility will generate
DDL for user defined table spaces, database partition groups and buffer
pools. DDL for the following database objects is extracted when using
the -l option:

* User-defined table spaces
* User-defined database partition groups
* User-defined buffer pools
Sep 1 '06 #2
Hi......
Thanks ...was able to generate the scripts...

Regards,
Tariq

Sep 1 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: CK | last post by:
Need a piece of advice on allocation of tablespaces for partitioning We are using a day level range-based approach as our parititiong scheme given that we have data inflows running into 15...
8
by: Joachim Mueller | last post by:
Have written a litte sql for showing the utilization of the tablespace. (found it within the newsgroup from Paul Vernon). Looks fine for an one Partition System only. But how i can I see on which...
22
by: Smutny30 | last post by:
Hello, I am preparing a database that will store 10 n * GBs - 100 n * GBs of data. I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on 4 GB box. I obtain : ...
6
by: mike_dba | last post by:
Can anyone tell me why a EEE system might be created to have two separate tablespaces with the same 4k pagesize ? They both appear to be in use as I can see the underlying files being modified. ...
0
by: sethwai | last post by:
Hi, A friend of mine inheritted a system that had 2 4k temp tablespaces each assigned to a different bufferpool. This brought up a number of questions for me. 1) Does anyone know in general...
1
by: rAinDeEr | last post by:
Hi, Am trying to create the DDL statements of a database using $ db2look -d TESTDB -e -z db2tar -i testiii -w test123 -m -o db2look.sql I get all the useful information except that of the...
10
by: rAinDeEr | last post by:
Hi, I am trying to create around 70 tablespaces for around 100 tables.. Am using DB2 UDB 8.2 in Linux environment... This is one i generated through Control centre.... CREATE REGULAR...
3
by: dcruncher4 | last post by:
DB2 8.2.3 the task I have is to write a script to restore a database from a backup on to another machine. the backup can be as old as seven years. The container layout on the machine to be...
4
by: beena | last post by:
All, I'm new to the concept of automatic storage... I'm looking at the database setup by a vendor. I see few tablespaces showing up with automatic storage - Yes. Tablespace ID ...
6
by: Troels Arvin | last post by:
Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF triggers. For various reasons, the exact same data...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.