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

Nov 12 '05 #1

Subscribe Reply

2279

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ämpf e
des 18. März in Berlin

Nov 12 '05 #2

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

Nov 12 '05 #3

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

Nov 12 '05 #4

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_instanc e>/NODE0000/SQL00001/).

Regards

--
Fabrizio Magni

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

replace mycontinent with europe

Nov 12 '05 #5

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_instanc e>/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

Nov 12 '05 #6

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\WE BSHOP\USERSPACE ') ...
USING ('d:\DB2DATA\WE BSHOP\SYSCAT') ...
USING ('d:\DB2DATA\WE BSHOP\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ämpf e
des 18. März in Berlin

Nov 12 '05 #7

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

Nov 12 '05 #8

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

Nov 12 '05 #9

Similar topics

3166

How Do We Configure the BOOST Filesystem Library?

by: perseus | last post by:

It is really crazy! I need to use the Boost filesystem for the manipulation of directories, and I have no idea how to install this filesystem on my IBM-compatible machine. Does anyone up here know how to do this? Thanks a million in advance! perseus

C / C++

5395

What a Funny Goup! I Asked a Question About Boost (C++ Filesystem Interface) & All I Got Is: My Question Is Irrelevant!

by: perseus | last post by:

I think that everyone who told me that my question is irrelevant, in particular Mr. David White, is being absolutely ridiculous. Obviously, most of you up here behave like the owners of the C++ language. A C++ interface installation IS ABOUT THE C++ LANGUAGE! The language does not possess the ability to handle even simple file directory manipulation. Those wise people that created it did not take care of it. So, BOOST is a portable...

C / C++

2281

boost::filesystem

by: Michael | last post by:

Is this the correct place to ask about Boost libs? If it is.............. #include <boost/filesystem/path.hpp> #include <boost/filesystem/operations.hpp> using namespace boost; using namespace boost::filesystem;

C / C++

3091

Project Naming, Design, Layout for a windows application

by: IT | last post by:

I looked thru the 7+ chapters and Microsoft seems vague. Bascially telling you to design it so it makes sense. Duh. Say I have an app that handles processes for the claims, finance and membership departments. First MSDN says the project should be. C:\Projects\MYSystem\MYSolution\MYApp. What is MySystem exactly. Why can't I find a sample that shows me the

Visual Basic .NET

1211

Solution Layout

by: IT | last post by:

Can someone email me a screenshot of their solution Explorer? I am trying to get an idea of how most developers lay this out. PPutzback@ECommunity.com Thanks in advance, Phil Putzback

Visual Basic .NET

2715

running postgresql database from loopback filesystem?

by: Jeff Davis | last post by:

I have virtual hosted users on a server and some of them have a postgresql database. I'm concerned about the outside possibility that a user could create an infinite loop and fill up the partition on which everyone's database resides. Anyway, it occured to me that I could create a special file for each database user of limited size, and make a filesystem on top of that file. The file could be owned by the user. Then, each user could have...

PostgreSQL Database

1781

filesystem option tuning

by: share-postgres | last post by:

Hi All, I have recently started evaluating Postgresql 7.4.2 to replace some *cough* more proprietary database systems... Thanks to the _excellent_ documentation (a point I cannot overemphasize) I was up and running in no time, and got a first test application running on the native C interface. There is just one point where I found the documentation lacking any description and practical hints (as opposed to all other topics), namely...

PostgreSQL Database

388

FAQ Topic - How can I access the client-side filesystem?

by: FAQ server | last post by:

----------------------------------------------------------------------- FAQ Topic - How can I access the client-side filesystem? ----------------------------------------------------------------------- Security means that by default you can't. In a more restricted enviroment, there are options. For example, using LiveConnect to connect to Java with Netscape, and using the FileSystemObject in IE. Check http://groups.google.com/

Javascript

3426

linker error building code with boost filesystem

by: GaryE | last post by:

Hello: I am having trouble linking a couple of files using the boost::filesystem. I am using MSVC 6.0. Here is an abbreviated version of my problem: foo.h: #ifndef __FOO_ #define __FOO_ #include "boost/filesystem.hpp"

C / C++

9666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9511

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10410

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9984

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9020

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5418

Trying to create a lan-to-lan vpn between two differents networks

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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4093

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3701

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General