Professional Web Applications Themes

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

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

  1. #1

    Default Unable to create a DMS DB under UDB 7.2

    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 Guest

  2. #2

    Default Re: Unable to create a DMS DB under UDB 7.2

    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
    >
    >
    P. Saint-Jacques Guest

  3. #3

    Default Re: Unable to create a DMS DB under UDB 7.2

    "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


    Le Blanc, Luc Guest

  4. #4

    Default Re: Unable to create a DMS DB under UDB 7.2

    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
    >
    >
    P. Saint-Jacques Guest

  5. #5

    Default Re: Unable to create a DMS DB under UDB 7.2

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

  6. #6

    Default Re: Unable to create a DMS DB under UDB 7.2

    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
    > > >
    > > >
    Luc Le Blanc Guest

  7. #7

    Default Re: Unable to create a DMS DB under UDB 7.2

    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
    >>>>
    >>>>
    >
    >
    P. Saint-Jacques Guest

Similar Threads

  1. Unable to create RSL
    By humancomputing in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 6th, 01:31 PM
  2. unable to create a dsn between CF 6.1 + SQL 2005
    By elvis is dead in forum Coldfusion Server Administration
    Replies: 4
    Last Post: November 22nd, 01:02 AM
  3. Unable to create collection
    By bram007 in forum Coldfusion Server Administration
    Replies: 0
    Last Post: June 26th, 11:33 AM
  4. Unable to create datasource
    By Scooby Doobie Doo in forum Macromedia ColdFusion
    Replies: 4
    Last Post: October 1st, 03:16 PM
  5. unable to create Web project
    By John Baima in forum ASP.NET General
    Replies: 3
    Last Post: January 12th, 09:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139