Unable to create a DMS DB under UDB 7.2 - IBM DB2

[Le Blanc, Luc]

I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.

CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
TABLESPACE MANAGED BY DATABASE USING
(FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
FILE 'D:\C15101\tblspace.003' 250000)
CATALOG TABLESPACE MANAGED BY SYSTEM USING
('D:\C15101\CATALOG')

The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.

To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...


--
Luc Le Blanc

[P. Saint-Jacques]

Luc, can youpost the error msg. you're getting.
One thing I see, you have not sized the container for the DMS tblspc.
for SYSCATSPACE. The end of your command has no spca defintion for the
container. I think you just forgot to post it!!
What does your db2diag.log say at the instance level?

Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
you go by recommendations, the catalog tblspc. should be in a SMS tblspc.

Get back to us and with msgs. we might be able to help.
PS: If you need to talk this over, I'm in Montreal. Use my id with
nospam removed and I'll call you.
HTH, Pierre.

Le Blanc, Luc wrote:

> I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.
>
> CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
> TABLESPACE MANAGED BY DATABASE USING
> (FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
> FILE 'D:\C15101\tblspace.003' 250000)
> CATALOG TABLESPACE MANAGED BY SYSTEM USING
> ('D:\C15101\CATALOG')
>
> The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
>
> To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
>
>
> --
> Luc Le Blanc
>
>

[Le Blanc, Luc]

"P. Saint-Jacques" a écrit :

> Luc, can youpost the error msg. you're getting.

SQL0980C Une erreur disque s'est produite. Les instructions SQL suivantes ne peuvent pas être traites. SQLSTATE=58005

> One thing I see, you have not sized the container for the DMS tblspc.
> for SYSCATSPACE. The end of your command has no spca defintion for the
> container. I think you just forgot to post it!!

No, the SYSCATSPACE is SMS. That's how I did under DB2/2 2.1. Is UDB 7.2 different?

> What does your db2diag.log say at the instance level?

2003-09-17-09.35.18.540000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:11 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -6651 IGNORED ... err loc 0
. Request follows...

2003-09-17-09.35.18.940000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:10 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -6651 IGNORED ... err loc 0
. Request follows...

2003-09-17-09.35.19.140000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:10 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = ADDDMSCONTAINER

2003-09-17-09.35.19.440000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:11 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = ADDDMSCONTAINER

2003-09-17-09.35.20.100000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:8 Appid:
buffer_pool_services sqlbDMSCreatePool Probe:800
DIA2802E Impossible de lire le fichier "".

ZRC=FFFFE605

2003-09-17-09.35.20.290000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:8 Appid:
buffer_pool_services sqlbDMSCreatePool Probe:800

Page=2

2003-09-17-09.35.20.450000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:8 Appid:
buffer_pool_services sqlbCreatePool Probe:920
DIA2802E Impossible de lire le fichier "".

ZRC=FFFFE605

2003-09-17-09.35.20.770000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:8 Appid:
data_management sqldPoolCreate Probe:273
DIA2802E Impossible de lire le fichier "".

ZRC=FFFFE605

2003-09-17-09.35.20.930000 Instance:DB2 Node:000
PID:61(DB2SYSC.EXE) TID:8 Appid:
base_sys_utilities sqleStartDb Probe:39

DiagData
05e6 ffff ....

> Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
> you go by recommendations, the catalog tblspc. should be in a SMS tblspc.

This is why I have

CATALOG TABLESPACE MANAGED BY SYSTEM USING ('D:\C15101\CATALOG')


--
Luc Le Blanc

> Le Blanc, Luc wrote:

> > I am trying to create a DB under UDB 7.2 for OS/2 using a time-provenhomemade REXX procedure. But all I get is a disk error SQL0980C.
> >
> > CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
> > TABLESPACE MANAGED BY DATABASE USING
> > (FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
> > FILE 'D:\C15101\tblspace.003' 250000)
> > CATALOG TABLESPACE MANAGED BY SYSTEM USING
> > ('D:\C15101\CATALOG')
> >
> > The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
> >
> > To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
> >
> >
> > --
> > Luc Le Blanc
> >
> >

--
Luc Le Blanc

[P. Saint-Jacques]

My mistake, I had read your syscatspace to be DMS, sorry.
As to the error, I remember encountering this since V7. It seems that
DB2 expects the path to the file container to exist before creating the
tblspc.
I don't remember or know if this was a change at V7. In the labs we run
in the classes at IBM we have the students create the directories for
the DMS file containers and then when they create the tblspc. they name
the file in that path and that works.
Maybe that's the workaround and that's why your command succeeded when
you created the three files, then DB2 found the path at create tblspc.
command time.
HTH, Pierre.
PS: I'll ask my colleagues to see if this is a change, requirement or
what and I'll keep in touch.

Le Blanc, Luc wrote:

> "P. Saint-Jacques" a écrit :
>
>

>>Luc, can youpost the error msg. you're getting.

>
>
> SQL0980C Une erreur disque s'est produite. Les instructions SQL suivantes ne peuvent pas être traites. SQLSTATE=58005
>
>

>>One thing I see, you have not sized the container for the DMS tblspc.
>>for SYSCATSPACE. The end of your command has no spca defintion for the
>>container. I think you just forgot to post it!!

>
>
> No, the SYSCATSPACE is SMS. That's how I did under DB2/2 2.1. Is UDB 7.2 different?
>
>

>>What does your db2diag.log say at the instance level?

>
>
> 2003-09-17-09.35.18.540000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:11 Appid:none
> buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>
> Prefetcher Error rc = -6651 IGNORED ... err loc 0
> . Request follows...
>
> 2003-09-17-09.35.18.940000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:10 Appid:none
> buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>
> Prefetcher Error rc = -6651 IGNORED ... err loc 0
> . Request follows...
>
> 2003-09-17-09.35.19.140000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:10 Appid:none
> buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>
> type = ADDDMSCONTAINER
>
> 2003-09-17-09.35.19.440000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:11 Appid:none
> buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>
> type = ADDDMSCONTAINER
>
> 2003-09-17-09.35.20.100000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:8 Appid:
> buffer_pool_services sqlbDMSCreatePool Probe:800
> DIA2802E Impossible de lire le fichier "".
>
> ZRC=FFFFE605
>
> 2003-09-17-09.35.20.290000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:8 Appid:
> buffer_pool_services sqlbDMSCreatePool Probe:800
>
> Page=2
>
> 2003-09-17-09.35.20.450000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:8 Appid:
> buffer_pool_services sqlbCreatePool Probe:920
> DIA2802E Impossible de lire le fichier "".
>
> ZRC=FFFFE605
>
> 2003-09-17-09.35.20.770000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:8 Appid:
> data_management sqldPoolCreate Probe:273
> DIA2802E Impossible de lire le fichier "".
>
> ZRC=FFFFE605
>
> 2003-09-17-09.35.20.930000 Instance:DB2 Node:000
> PID:61(DB2SYSC.EXE) TID:8 Appid:
> base_sys_utilities sqleStartDb Probe:39
>
> DiagData
> 05e6 ffff ....
>
>
>

>>Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
>>you go by recommendations, the catalog tblspc. should be in a SMS tblspc.

>
>
> This is why I have
>
> CATALOG TABLESPACE MANAGED BY SYSTEM USING ('D:\C15101\CATALOG')
>
>
> --
> Luc Le Blanc
>
>
>
>

>>Le Blanc, Luc wrote:
>>

>>>I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.
>>>
>>>CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
>>>TABLESPACE MANAGED BY DATABASE USING
>>>(FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
>>>FILE 'D:\C15101\tblspace.003' 250000)
>>>CATALOG TABLESPACE MANAGED BY SYSTEM USING
>>>('D:\C15101\CATALOG')
>>>
>>>The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
>>>
>>>To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
>>>
>>>
>>>--
>>>Luc Le Blanc
>>>
>>>

>
>
> --
> Luc Le Blanc
>
>

[Luc Le Blanc]

"P. Saint-Jacques" a écrit :

> My mistake, I had read your syscatspace to be DMS, sorry.
> As to the error, I remember encountering this since V7. It seems that
> DB2 expects the path to the file container to exist before creating the
> tblspc.
> I don't remember or know if this was a change at V7. In the labs we run
> in the classes at IBM we have the students create the directories for
> the DMS file containers and then when they create the tblspc. they name
> the file in that path and that works.
> Maybe that's the workaround and that's why your command succeeded when
> you created the three files, then DB2 found the path at create tblspc.
> command time.

Whether I create the directory before launching the command makes no difference (it fails). But the containers? I would have to create 3 empty 1Gb files? The same proc worked at other sites without a problem :(


--
Luc Le Blanc

> Le Blanc, Luc wrote:

> > "P. Saint-Jacques" a écrit :
> >
> >

> >>Luc, can youpost the error msg. you're getting.

> >
> >
> > SQL0980C Une erreur disque s'est produite. Les instructions SQL suivantes ne peuvent pas être traites. SQLSTATE=58005
> >
> >

> >>One thing I see, you have not sized the container for the DMS tblspc.
> >>for SYSCATSPACE. The end of your command has no spca defintion for the
> >>container. I think you just forgot to post it!!

> >
> >
> > No, the SYSCATSPACE is SMS. That's how I did under DB2/2 2.1. Is UDB 7.2 different?
> >
> >

> >>What does your db2diag.log say at the instance level?

> >
> >
> > 2003-09-17-09.35.18.540000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:11 Appid:none
> > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> >
> > Prefetcher Error rc = -6651 IGNORED ... err loc 0
> > . Request follows...
> >
> > 2003-09-17-09.35.18.940000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:10 Appid:none
> > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> >
> > Prefetcher Error rc = -6651 IGNORED ... err loc 0
> > . Request follows...
> >
> > 2003-09-17-09.35.19.140000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:10 Appid:none
> > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> >
> > type = ADDDMSCONTAINER
> >
> > 2003-09-17-09.35.19.440000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:11 Appid:none
> > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> >
> > type = ADDDMSCONTAINER
> >
> > 2003-09-17-09.35.20.100000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > buffer_pool_services sqlbDMSCreatePool Probe:800
> > DIA2802E Impossible de lire le fichier "".
> >
> > ZRC=FFFFE605
> >
> > 2003-09-17-09.35.20.290000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > buffer_pool_services sqlbDMSCreatePool Probe:800
> >
> > Page=2
> >
> > 2003-09-17-09.35.20.450000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > buffer_pool_services sqlbCreatePool Probe:920
> > DIA2802E Impossible de lire le fichier "".
> >
> > ZRC=FFFFE605
> >
> > 2003-09-17-09.35.20.770000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > data_management sqldPoolCreate Probe:273
> > DIA2802E Impossible de lire le fichier "".
> >
> > ZRC=FFFFE605
> >
> > 2003-09-17-09.35.20.930000 Instance:DB2 Node:000
> > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > base_sys_utilities sqleStartDb Probe:39
> >
> > DiagData
> > 05e6 ffff ....
> >
> >
> >

> >>Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
> >>you go by recommendations, the catalog tblspc. should be in a SMS tblspc.

> >
> >
> > This is why I have
> >
> > CATALOG TABLESPACE MANAGED BY SYSTEM USING ('D:\C15101\CATALOG')
> >
> >
> > --
> > Luc Le Blanc
> >
> >
> >
> >

> >>Le Blanc, Luc wrote:
> >>
> >>>I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.
> >>>
> >>>CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
> >>>TABLESPACE MANAGED BY DATABASE USING
> >>>(FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
> >>>FILE 'D:\C15101\tblspace.003' 250000)
> >>>CATALOG TABLESPACE MANAGED BY SYSTEM USING
> >>>('D:\C15101\CATALOG')
> >>>
> >>>The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
> >>>
> >>>To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
> >>>
> >>>
> >>>--
> >>>Luc Le Blanc
> >>>
> >>>

> >
> >
> > --
> > Luc Le Blanc
> >
> >

[Luc Le Blanc]

I found a workaround: create the DMS DB with a single container in the userspace1 tablespace, connect to the DB, and add 2 more containers. Same hard drive, same filenames, same size. Don't ask me why this works and it did not work right in the first place, nor why the original 3
containers at once procedure works on other machines, but it works. Phew!


--
Luc Le Blanc


I previously wrote :

> "P. Saint-Jacques" a écrit :
>

> > My mistake, I had read your syscatspace to be DMS, sorry.
> > As to the error, I remember encountering this since V7. It seems that
> > DB2 expects the path to the file container to exist before creating the
> > tblspc.
> > I don't remember or know if this was a change at V7. In the labs we run
> > in the classes at IBM we have the students create the directories for
> > the DMS file containers and then when they create the tblspc. they name
> > the file in that path and that works.
> > Maybe that's the workaround and that's why your command succeeded when
> > you created the three files, then DB2 found the path at create tblspc.
> > command time.

>
> Whether I create the directory before launching the command makes no difference (it fails). But the containers? I would have to create 3 empty 1Gb files? The same proc worked at other sites without a problem :(
>
> --
> Luc Le Blanc
>

> > Le Blanc, Luc wrote:

> > > "P. Saint-Jacques" a écrit :
> > >
> > >
> > >>Luc, can youpost the error msg. you're getting.
> > >
> > >
> > > SQL0980C Une erreur disque s'est produite. Les instructions SQL suivantes ne peuvent pas être traites. SQLSTATE=58005
> > >
> > >
> > >>One thing I see, you have not sized the container for the DMS tblspc.
> > >>for SYSCATSPACE. The end of your command has no spca defintion for the
> > >>container. I think you just forgot to post it!!
> > >
> > >
> > > No, the SYSCATSPACE is SMS. That's how I did under DB2/2 2.1. Is UDB 7.2 different?
> > >
> > >
> > >>What does your db2diag.log say at the instance level?
> > >
> > >
> > > 2003-09-17-09.35.18.540000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:11 Appid:none
> > > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> > >
> > > Prefetcher Error rc = -6651 IGNORED ... err loc 0
> > > . Request follows...
> > >
> > > 2003-09-17-09.35.18.940000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:10 Appid:none
> > > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> > >
> > > Prefetcher Error rc = -6651 IGNORED ... err loc 0
> > > . Request follows...
> > >
> > > 2003-09-17-09.35.19.140000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:10 Appid:none
> > > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> > >
> > > type = ADDDMSCONTAINER
> > >
> > > 2003-09-17-09.35.19.440000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:11 Appid:none
> > > buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
> > >
> > > type = ADDDMSCONTAINER
> > >
> > > 2003-09-17-09.35.20.100000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > > buffer_pool_services sqlbDMSCreatePool Probe:800
> > > DIA2802E Impossible de lire le fichier "".
> > >
> > > ZRC=FFFFE605
> > >
> > > 2003-09-17-09.35.20.290000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > > buffer_pool_services sqlbDMSCreatePool Probe:800
> > >
> > > Page=2
> > >
> > > 2003-09-17-09.35.20.450000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > > buffer_pool_services sqlbCreatePool Probe:920
> > > DIA2802E Impossible de lire le fichier "".
> > >
> > > ZRC=FFFFE605
> > >
> > > 2003-09-17-09.35.20.770000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > > data_management sqldPoolCreate Probe:273
> > > DIA2802E Impossible de lire le fichier "".
> > >
> > > ZRC=FFFFE605
> > >
> > > 2003-09-17-09.35.20.930000 Instance:DB2 Node:000
> > > PID:61(DB2SYSC.EXE) TID:8 Appid:
> > > base_sys_utilities sqleStartDb Probe:39
> > >
> > > DiagData
> > > 05e6 ffff ....
> > >
> > >
> > >
> > >>Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
> > >>you go by recommendations, the catalog tblspc. should be in a SMS tblspc.
> > >
> > >
> > > This is why I have
> > >
> > > CATALOG TABLESPACE MANAGED BY SYSTEM USING ('D:\C15101\CATALOG')
> > >
> > >
> > > --
> > > Luc Le Blanc
> > >
> > >
> > >
> > >
> > >>Le Blanc, Luc wrote:
> > >>
> > >>>I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.
> > >>>
> > >>>CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
> > >>>TABLESPACE MANAGED BY DATABASE USING
> > >>>(FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
> > >>>FILE 'D:\C15101\tblspace.003' 250000)
> > >>>CATALOG TABLESPACE MANAGED BY SYSTEM USING
> > >>>('D:\C15101\CATALOG')
> > >>>
> > >>>The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
> > >>>
> > >>>To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
> > >>>
> > >>>
> > >>>--
> > >>>Luc Le Blanc
> > >>>
> > >>>
> > >
> > >
> > > --
> > > Luc Le Blanc
> > >
> > >

[P. Saint-Jacques]

I guess this one goes on to prove that "The ways of God (and DB2 ?) are
many and myterious".
Bonjour, Pierre.

Luc Le Blanc wrote:

> I found a workaround: create the DMS DB with a single container in the userspace1 tablespace, connect to the DB, and add 2 more containers. Same hard drive, same filenames, same size. Don't ask me why this works and it did not work right in the first place, nor why the original 3
> containers at once procedure works on other machines, but it works. Phew!
>
>
> --
> Luc Le Blanc
>
>
> I previously wrote :
>
>

>>"P. Saint-Jacques" a écrit :
>>
>>

>>>My mistake, I had read your syscatspace to be DMS, sorry.
>>>As to the error, I remember encountering this since V7. It seems that
>>>DB2 expects the path to the file container to exist before creating the
>>>tblspc.
>>>I don't remember or know if this was a change at V7. In the labs we run
>>>in the classes at IBM we have the students create the directories for
>>>the DMS file containers and then when they create the tblspc. they name
>>>the file in that path and that works.
>>>Maybe that's the workaround and that's why your command succeeded when
>>>you created the three files, then DB2 found the path at create tblspc.
>>>command time.

>>
>>Whether I create the directory before launching the command makes no difference (it fails). But the containers? I would have to create 3 empty 1Gb files? The same proc worked at other sites without a problem :(
>>
>>--
>>Luc Le Blanc
>>
>>

>>>Le Blanc, Luc wrote:
>>>
>>>> "P. Saint-Jacques" a écrit :
>>>>
>>>>
>>>>
>>>>>Luc, can youpost the error msg. you're getting.
>>>>
>>>>
>>>> SQL0980C Une erreur disque s'est produite. Les instructions SQL suivantes ne peuvent pas être traites. SQLSTATE=58005
>>>>
>>>>
>>>>
>>>>>One thing I see, you have not sized the container for the DMS tblspc.
>>>>>for SYSCATSPACE. The end of your command has no spca defintion for the
>>>>>container. I think you just forgot to post it!!
>>>>
>>>>
>>>>No, the SYSCATSPACE is SMS. That's how I did under DB2/2 2.1. Is UDB 7.2 different?
>>>>
>>>>
>>>>
>>>>>What does your db2diag.log say at the instance level?
>>>>
>>>>
>>>>2003-09-17-09.35.18.540000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:11 Appid:none
>>>>buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>>>>
>>>>Prefetcher Error rc = -6651 IGNORED ... err loc 0
>>>>. Request follows...
>>>>
>>>>2003-09-17-09.35.18.940000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:10 Appid:none
>>>>buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>>>>
>>>>Prefetcher Error rc = -6651 IGNORED ... err loc 0
>>>>. Request follows...
>>>>
>>>>2003-09-17-09.35.19.140000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:10 Appid:none
>>>>buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>>>>
>>>>type = ADDDMSCONTAINER
>>>>
>>>>2003-09-17-09.35.19.440000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:11 Appid:none
>>>>buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
>>>>
>>>>type = ADDDMSCONTAINER
>>>>
>>>>2003-09-17-09.35.20.100000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:8 Appid:
>>>>buffer_pool_services sqlbDMSCreatePool Probe:800
>>>>DIA2802E Impossible de lire le fichier "".
>>>>
>>>>ZRC=FFFFE605
>>>>
>>>>2003-09-17-09.35.20.290000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:8 Appid:
>>>>buffer_pool_services sqlbDMSCreatePool Probe:800
>>>>
>>>> Page=2
>>>>
>>>>2003-09-17-09.35.20.450000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:8 Appid:
>>>>buffer_pool_services sqlbCreatePool Probe:920
>>>>DIA2802E Impossible de lire le fichier "".
>>>>
>>>>ZRC=FFFFE605
>>>>
>>>>2003-09-17-09.35.20.770000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:8 Appid:
>>>>data_management sqldPoolCreate Probe:273
>>>>DIA2802E Impossible de lire le fichier "".
>>>>
>>>>ZRC=FFFFE605
>>>>
>>>>2003-09-17-09.35.20.930000 Instance:DB2 Node:000
>>>>PID:61(DB2SYSC.EXE) TID:8 Appid:
>>>>base_sys_utilities sqleStartDb Probe:39
>>>>
>>>>DiagData
>>>>05e6 ffff ....
>>>>
>>>>
>>>>
>>>>
>>>>>Also, is there a specific reason for a DMS tblspc. for SYSCATSPACE? If
>>>>>you go by recommendations, the catalog tblspc. should be in a SMS tblspc.
>>>>
>>>>
>>>>This is why I have
>>>>
>>>>CATALOG TABLESPACE MANAGED BY SYSTEM USING ('D:\C15101\CATALOG')
>>>>
>>>>
>>>>--
>>>>Luc Le Blanc
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Le Blanc, Luc wrote:
>>>>>
>>>>>
>>>>>>I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C.
>>>>>>
>>>>>>CREATE DATABASE C15101 USING CODESET IBM-863 TERRITORY CA USER
>>>>>>TABLESPACE MANAGED BY DATABASE USING
>>>>>>(FILE 'D:\C15101\tblspace.001' 250000,FILE 'D:\C15101\tblspace.002' 250000,
>>>>>>FILE 'D:\C15101\tblspace.003' 250000)
>>>>>>CATALOG TABLESPACE MANAGED BY SYSTEM USING
>>>>>>('D:\C15101\CATALOG')
>>>>>>
>>>>>>The 3 containers would require 3Gb of disk space, yet the hard disk is HPFS and has 6Gb of free space. After the operation fails, the d:\C15101 directory is empty but undeletable unless I reboot. The result is the same, whether I create the directory before creating the DB or not.
>>>>>>
>>>>>>To eliminate the possibility of a true disk error, I sucessfully copied 3 1Gb files into this directory...
>>>>>>
>>>>>>
>>>>>>--
>>>>>>Luc Le Blanc
>>>>>>
>>>>>>
>>>>
>>>>
>>>>--
>>>>Luc Le Blanc
>>>>
>>>>

>
>