filesystem layout for installing db2

[Fabrizio Magni]

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

--
Fabrizio Magni

fa************@mycontinent.com

replace mycontinent with europe

[Bernd Hohmann]

Fabrizio Magni wrote:

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

--
"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

[Fabrizio Magni]

Bernd Hohmann wrote:

Fabrizio Magni wrote:

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).

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

--
Fabrizio Magni

fa************@mycontinent.com

replace mycontinent with europe

[Norbert Munkel]

Hi Fabrizio,

Fabrizio Magni wrote:

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/infoce...help/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...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

[Fabrizio Magni]

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

--
Fabrizio Magni

fa************@mycontinent.com

replace mycontinent with europe

[Norbert Munkel]

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

[Bernd Hohmann]

Fabrizio Magni wrote:

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

--
"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

[aj]

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

Fabrizio Magni wrote:

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

[Fabrizio Magni]

Many thanks for all the answers.

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

Regards

--
Fabrizio Magni

fa************@mycontinent.com

replace mycontinent with europe