Informix recommend that symbolic links be used for chunks. These links
are then used in the dbspace definition.
Does this advice hold for DB2? The equivalent would be to create
symbolic links for containers and use the link name when defining
tablespaces. Wouldn't this allow containers to be physically moved/
renamed without having to use db2relocatedb?
I haven't tested this but couldn't you just remove the link, move the
container, re-create the link using the original link name?
Thanks in advance.
2  2868 
"Desmodromi c" <da*******@yaho o.com.auwrote in message
news:9b******** *************** ***********@z16 g2000prn.google groups.com...
Informix recommend that symbolic links be used for chunks. These links
are then used in the dbspace definition.
Does this advice hold for DB2? The equivalent would be to create
symbolic links for containers and use the link name when defining
tablespaces. Wouldn't this allow containers to be physically moved/
renamed without having to use db2relocatedb?
I haven't tested this but couldn't you just remove the link, move the
container, re-create the link using the original link name?
Thanks in advance.
I can't tell you for sure that it will not work, but I have never seen it
recommended by IBM for DB2.
Symbolic links are set up by DB2 for pointers to the DB2 libraries under
each instance directory.
Desmodromic wrote:
Informix recommend that symbolic links be used for chunks. These links
are then used in the dbspace definition.
Does this advice hold for DB2? The equivalent would be to create
symbolic links for containers and use the link name when defining
tablespaces.
I, too did this under Informix. When I converted to DB2, I continued to
do it w/ v7 and v8 with DMS containers. I cannot speak for v9. I'm on
Red Hat EL AS 4.4, btw.
It works /perfectly/ fine, and gives the DBA a level of indirection w/
containers, which can be very useful. DB2 has no idea its hitting a
symlink - the OS takes care of it.
Wouldn't this allow containers to be physically moved/
renamed without having to use db2relocatedb?
Yes, exactly. Of course, make darn sure DB2 is offline when you do
this. :)
I haven't tested this but couldn't you just remove the link, move the
container, re-create the link using the original link name?
Thanks in advance.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ozarks |
last post by:
I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and can't
seem to get it working. Here is my setup....
- I am running MySQL 4.1.7
- I have tried this with both the 'mysqld-max' and 'mysqld-max-nt'
servers
- Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in
|
by: Mark Everett |
last post by:
Hi,
I am runnign the latest version of mysql and I desperately need to
move one of my tables from a database so that it is stored on another
drive.
I have read the symbolic links reference but it seems to me that I can
relocate a database but not a table. Which is not useful to me at all.
I have tried anyhow without any success.
|
by: mp |
last post by:
i have a python program which attempts to call 'cls' but fails:
sh: line 1: cls: command not found
i tried creating an alias from cls to clear in .profile, .cshrc, and
/etc/profile, but none of these options seem to work.
my conclusion is that a python program that is executing does not use
the shell (because it does not recognize shell aliases). is this
correct?
|
by: TK |
last post by:
Hi,
I have to know whether a typical file (under Linux) a symbolic link is
(in the sense of the stat()-Funktion). How can I check it excactly?
Thanks for help.
o-o
THomas
|
by: humbleaptience |
last post by:
Hey Ya'll,
I basically have a bunch of unix servers with a dataset scrambled
through about 10 of them. On unix, I maintain a symbolic link file
tree so that for each server it appears to have access to all the
files through auto mounting and so forth. I want to be able to
access this same file tree from my asp.net web app and NFS - however,
it's not working and I've tried everything. Microsoft Services for
Unix just doesn't cut it...
| | |
by: xhunga |
last post by:
* Symbolic computation with the language c :
The Derivative step by step.
(Windows,Linux)
You can find some examples into the file a_exampl.txt
@
@
|
by: Remote_User |
last post by:
Hi All,
.NET 1.1 doesn't support creating symbolic links to files,
like in Linux? Can i use C# to make a file point to another file?
Thanks.
|
by: amygrant1701 |
last post by:
Hi,
I've done this before so I don't see what I could doing wrong here.
I'm running mysql 5x on freebsd. I'm using the default data directory
of "/var/db/mysql"
In there I have several dozen mysql datasbases that are functioning
perfectly. I am trying to add a database which will be stored on a
different drive, therefore the entry in "/var/db/mysql" should be a
symbolic link
|
by: sora |
last post by:
Hi,
I've developed a MFC program under VS 6.0. My debugger *was* working fine and I've used it often for my project. Then, one day, the errors below appear and they prevent me from using the debugger. I know that I get these warnings because the OS symbols arn't installed (a few of them loaded fine).
As far as I can remember, I didn't touch anything that should mess with the debugger so I don't know how to fix it and I need to be able to...
|
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...
|
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,...
| | |
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...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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
| | |
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...
| |
