Moving db2 to a dedicated partion

db2udbgirl

When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in
/home/db2inst1 (and I didn't care about it much then but now I would
like to move the same instance of DB2 to a dedicated filesystem. May I
know the steps involved in doing this migration activity.
Thanks,
db2udbgirl

Apr 7 '06 #1

Subscribe Post Reply

1283

Gert van der Kooij

In article <11**********************@z34g2000cwc.googlegroups .com>,
db********@gmail.com says...

When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in
/home/db2inst1 (and I didn't care about it much then but now I would
like to move the same instance of DB2 to a dedicated filesystem. May I
know the steps involved in doing this migration activity.

A short action list:

0 - if located in homedir relocate databases out of the homedir with
db2relocatedb
1 - List your cataloged nodes/databases (list node/db directory)
2 - drop the instance (db2idrop)
3 - set the new homedir for the instance user
4 - create the instance (db2icrt)
5 - catalog the nodes/databases again (catalog node/db directory)

Apr 7 '06 #2

Similar topics

Who spawns a dedicated server process?

by: Michael J. Moore | last post by:

Is it the listener process, or some other Oracle process. Also, on a UNIX system, when you do "ps -ef" to see your processes, the PPID points back to a process named "init". Why does the PPID not...

Oracle Database

moving a heap to another filegroup

by: el emperador | last post by:

I have a big table (heap)... well, not so big, I have a small server and I want to spread access to it across several new disks dedicated only to that table. I known its possible to do that...

Microsoft SQL Server

[BCB] moving components at runtime

by: Borys Power | last post by:

Hi, Can anyone tell me how to drag labels or any other objects by mouse? br -- Borys Power

C / C++

Yes, this is a python question,and a serious one at that (moving to Win XP)

by: Kenneth McDonald | last post by:

For unfortunate reasons, I'm considering switching back to Win XP (from OS X) as my "main" system. Windows has so many annoyances that I can only compare it to driving in the Bay Area at rush hour...

Python

Problems moving from ACCESS to MS SQL

by: LaSalamandra | last post by:

have a dedicated web server with Win2000 and CF MX Server. I always used ACCESS databases. Now, I bought a space under a MS SQL Server and I'm moving all my databases there. Today I moved my...

Microsoft Access / VBA

Moving SQL installation to a new Partition

by: Marc C | last post by:

Hello, I have a SQL 2000 installation on a small partion that I would like to move to a second larger partion on the same disk array array with the config as follows: d: full installation of prod...

Microsoft SQL Server

VS2005,VB,BindingNavigator: programmatically moving to record

by: Dale Sampson | last post by:

As you can tell, I am new to VS.net. I have a VB project with a defined data source pointing to a table in a ..mdb file.-- The associated fields are displayed in textboxes using the...

.NET Framework

Moving listbox items from one to another

by: Brian Simmons | last post by:

Hi All, I search on codeproject and google but didn't find what I was looking for. Anybody know of a good implementation where you have 2 listboxes and you want to move items between the 2. ...

ASP.NET

Moving from IIS6 to IIS7 and it won't load

by: David Thielen | last post by:

So we have moved our app from .NET version 2.X in IIS6 to a Windows 2008 Server running IIS7. We have copied all files to the Windwardreports\apps directory and that apps directory has been...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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

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

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

Windows Server