filesystem layout for installing db2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fabrizio Magni - 28 Sep 2005 22:01 GMT

Hello,
I'm a newbie with DB2 and I'd like to know if a standardized layout
exists for planning a proper installation. I'm referring to something
similar to OFA for Oracle.

I couldn't find anything googling around or checking on the IBM website
but probably I lack the DB2 basics.

Anybody with some good link where to check or with suggestion on how to
plan the installation?

Many thanks

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message

Bernd Hohmann - 28 Sep 2005 22:32 GMT

> I'm a newbie with DB2 and I'd like to know if a standardized layout
> exists for planning a proper installation.

Well - without knowing your requirements a simple sequence of "Next >>"
clicks during installation and table creation will serve your needs.

The DB2 controlcenter is very helpful because it has Q&A windows
everywhere and you can grab the SQL commands for every step with the
"View SQL" button (or what ever it is named in your language & DB2 version).

Bernd

Signature

"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

Reply to this Message

Fabrizio Magni - 29 Sep 2005 07:37 GMT

>> I'm a newbie with DB2 and I'd like to know if a standardized layout
>> exists for planning a proper installation.
[quoted text clipped - 6 lines]
> "View SQL" button (or what ever it is named in your language & DB2
> version).

Hi Bernd and thanks for the answer.

Actually I'm looking on how to prepare the filesystem tree in advance.

where to place data, logs, binaries, etc.

If to divide them for instance and/or databases... and if a standard for
such a tree is provided/suggested by IBM or the DB2 community.

Many thanks

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message

Norbert Munkel - 29 Sep 2005 08:20 GMT

Hi Fabrizio,

> Actually I'm looking on how to prepare the filesystem tree in advance.
>
> where to place data, logs, binaries, etc.
>
> If to divide them for instance and/or databases... and if a standard for
> such a tree is provided/suggested by IBM or the DB2 community.

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

In the index-frame, choose "Design->Database Systems->Physical Database
Design

If you need more information, the reference manuals

Administration Guide: Planning
Administration Guide: Implementation

They should be on the documentation cd and are available online:

http://www.ibm.com/software/data/db2/udb/support/manualsv8.html

As a newbie to db2

http://www.ibm.com/developerworks/db2/newto/

would be a good start.

IBM offers special training for experienced DBAs who are new to DB2.
This might be an option for you as well.

As you are asking for the community:

http://www.idug.org (Independent DB2 Users Group)

Have Fun,

Norbert

Reply to this Message

Fabrizio Magni - 29 Sep 2005 08:54 GMT

Thank you, Norbert.

The planning guide is more or less what I was looking for.

Just a question.

I cannot find any good reference to where placing the transactional logs.

Tha DB2 on linux HOWTO place them (mirrored) on two different
directories (ex: /db2log1).

Is it the proper way?
Should I generate sublevels to divide the log as than for containers?
(from the planning guide:
<your_directory>/<your_instance>/NODE0000/SQL00001/).

Regards

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message

Norbert Munkel - 29 Sep 2005 11:12 GMT

Hi Fabrizio,

Fabrizio Magni schrieb:

> I cannot find any good reference to where placing the transactional logs.

Can be every directory. It is common sense that placing the logs on
other devices than the database containers is not a bad idea in terms of
performance.

> Tha DB2 on linux HOWTO place them (mirrored) on two different
> directories (ex: /db2log1).
> Is it the proper way?

It is always nice to have a copy ;-)
This should answer the question.

> Should I generate sublevels to divide the log as than for containers?
> (from the planning guide:
> <your_directory>/<your_instance>/NODE0000/SQL00001/).

Depends on your personal environment and taste. But I would not argue
with the authors of the planning guide.

BTW: I just know where the Documentation resides. That does not mean I
have read it completely. ;-)

Best regards,

Norbert

Reply to this Message

Bernd Hohmann - 29 Sep 2005 12:32 GMT

> Actually I'm looking on how to prepare the filesystem tree in advance.
>
> where to place data, logs, binaries, etc.

Well, I'm usually using a flat design (but I don't have any really large
databases).

There is a directory \DB2DATA where all other databases are placed below.

CREATE DATABASE WEBSHOP ON D:
USING CODESET IBM-850 TERRITORY DE COLLATE
USING SYSTEM USER TABLESPACE MANAGED BY SYSTEM
USING ('d:\DB2DATA\WEBSHOP\USERSPACE') ...
USING ('d:\DB2DATA\WEBSHOP\SYSCAT') ...
USING ('d:\DB2DATA\WEBSHOP\TEMP') ...

and so on.

Bernd

Signature

Reply to this Message

aj - 29 Sep 2005 19:08 GMT

Here's how I do it. Indenting implies directory structure.

HTH
aj

/db2
/llogs            DB logical logs archived from ANOTHER                             DB2 server
/<DB>            For each DB whose logs we archive
/NODE0000        DB2 creates this automatically - used                             for EE
nodes
/backups            Local DB2 DB backups
/<DB>            For each local DB we backup
/ascii            Ascii database table dumps
/<DB>            For each local DB on which we do ascii                             dumps
/containers            All DB2 data is stored in DB-Managed                             Space
(DMS) container files
/<DB>            For each local DB
/logs            Logical logs for that local DB
/tmp            System-Managed Space (SMS) for DB temp                             data
/tmp32k        DB temp data w/ 32k page size
/user_tmp        User temp data
/user_tmp8k        User temp data w/ 8k page size
/userexit            Userexit is how logical logs are                             archived to
another servers                             /db2/llogs
/<DB>            For each DB
ARCHIVE.LOG        A log of all userexit archives and                             results
USEREXIT.ERR    Any errors from userexit archives
/dbabin            Home-brewed database                                     executables/apps/utilities
/lifeboat            Backup of DB configuration
/<SERVER>            For each DB2 server lifeboat
/instance        At instance level
/database        At database level

> Hello,
> I'm a newbie with DB2 and I'd like to know if a standardized layout
[quoted text clipped - 8 lines]
>
> Many thanks

Reply to this Message

Fabrizio Magni - 30 Sep 2005 07:45 GMT

Many thanks for all the answers.

I'm going to install the DB2 on linux in a couple of hours.

Regards

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message