> > > "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
> > >
> > >
Bookmarks