Ask a Question related to IBM DB2, Design and Development.
-
xixi #1
create table space
i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can
create DMS to achieve high performance, to add the container, i can do
file or device, which is preferable?
after i create a DMS table space on raw device, i want to alter it by
altering the container size ( from 4000 mb to 5000 mb), but get bad
container error? why is that?
xixi Guest
-
how to create a Indexed color space
Hi, I am trying to create any "Indexed" colorspace but I always fail. This is the simplest code I've tried PDEIndexedColorData* csData = new... -
table space impact on query optimization
Hi, based on the doc, ther are two characteristics which is overhead and transferrate have impact on the I/O cose duing query execution. Since i... -
alter a DMS table space
hello, i am using db2 udb v8.1 on windows, i am using DMS for table data, i need to increase the size for the table space, is this the right... -
Empty table, why so many space ?
"MaisonBorniol" <maisonborniol@nomade.fr> wrote in message news:29f4fc84.0306260116.6aeefcb@posting.google.com... The minimum space allocated is... -
script for table extent space used
"Howard J. Rogers" <howardjr2000@yahoo.com.au> wrote in message news:_%SL9.5485$jM5.15508@newsfeeds.bigpond.com... < Big Juicy Snip> the Hi... -
Blair Adamache #2
Re: create table space
If you're going to use DMS for performance reasons, go with raw. For
more info on raw versus cooked, see:
[url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/adamache/0621_adamache.html[/url]
Basically, if you use DMS with files, you're getting the worst of both
worlds: the performance of the file system with the administrative
overhead of DMS table spaces.
xixi wrote:
> i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can
> create DMS to achieve high performance, to add the container, i can do
> file or device, which is preferable?
>
> after i create a DMS table space on raw device, i want to alter it by
> altering the container size ( from 4000 mb to 5000 mb), but get bad
> container error? why is that?Blair Adamache Guest
-
xixi #3
Re: create table space
hi,
my admin told me he has converted the physical device to a volume, so
if i create a DMS using raw device , then if i want to backup and
restore in other windows platform machine without volume drive, will
the restore still works? thanks
xixi Guest
-
Kelly D. Rodger #4
Re: create table space
You can use a redirected restore to restore on another machine with
different container paths. As long as you supply some suitably large
DMS containers, that could mean a different volumes, or even a DMS file.
Hope that helps.
kdr
xixi wrote:
--> my admin told me he has converted the physical device to a volume, so
> if i create a DMS using raw device , then if i want to backup and
> restore in other windows platform machine without volume drive, will
> the restore still works? thanks
------------------------------------------------------------------
Kelly D. Rodger IBM Canada
DB2 UDB Backup and Recovery Toronto Lab
------------------------------------------------------------------
Kelly D. Rodger Guest
-
DONIKAPATEL #5
create forum and blog in DB2 ?
Can any one tell me:-
How to create forum and blog in DB2 using other software like websphere Portal, Websphere server application,Tivoli Directory server,etc ?DONIKAPATEL Guest



Reply With Quote

