Professional Web Applications Themes

SQL1034C error when creating stored procedure - IBM DB2

Hi, I'm new in DB2 and have installed an evaluation version 8.1 on a winxp system. I have created a database and will make stored procedure on it but when I buil the SP an error occured : ////////// SELECTCANTON2003SCHEMA.PROCEDURE1 - La construction a démarré. Création de procédure mémorisée - Code retour -1034. [IBM][CLI Driver][DB2/NT] SQL1034C La base de données est altérée. Toutes les applications utilisant la base ont été arrêtées. SQLSTATE=58031 SELECTCANTON2003SCHEMA.PROCEDURE1 - La construction a échoué. [IBM][CLI Driver] SQL1224N Un agent de base de données n'a pas pu être démarré pour satisfaire une demande ou a été interrompu ...

  1. #1

    Default SQL1034C error when creating stored procedure

    Hi,

    I'm new in DB2 and have installed an evaluation version 8.1 on a winxp
    system.

    I have created a database and will make stored procedure on it but
    when I buil the SP an error occured :

    //////////

    SELECTCANTON2003SCHEMA.PROCEDURE1 - La construction a démarré.
    Création de procédure mémorisée - Code retour -1034.
    [IBM][CLI Driver][DB2/NT] SQL1034C La base de données est altérée.
    Toutes les applications utilisant la base ont été arrêtées.
    SQLSTATE=58031


    SELECTCANTON2003SCHEMA.PROCEDURE1 - La construction a échoué.
    [IBM][CLI Driver] SQL1224N Un agent de base de données n'a pas pu être
    démarré pour satisfaire une demande ou a été interrompu à la suite
    d'un arrêt normal du système ou d'une commande FORCE. SQLSTATE=55032


    SELECTCANTON2003SCHEMA.PROCEDURE1 - L'annulation a échoué.

    /////////

    This message is in french but I think someone know the SQL1034C error.

    I saw in this group that when this error appears we must restore
    database or re-create it. I have re-create the database but the same
    error appears. I have already made the "db2dart database /DB" commande
    but the result says that all is ok. I join here the db2dart.rpt. Could
    someone help me please? It's very important. You could answer here or
    by mail at hevs.ch

    Thank you


    db2dart.rpt


    __________________________________________________ ____________________________



    _______ DART _______

    D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o
    o l

    IBM DB2 NT





    __________________________________________________ ____________________________

    DART (V8.1.0) Report:
    10/08/03 10:52:17 Europe de l'Ouest (heure d'été)

    Database Name: RATE2003
    Report name: RATE2003.RPT
    Database Subdirectory: C:\DB2\NODE0000\SQL00004
    Operational Mode: Database Inspection Only (INSPECT)

    __________________________________________________ ____________________________
    ------------------------------------------------------------------------------


    Action option: DB

    Connecting to Buffer Pool Services...

    Database inspection phase start.

    Tablespace file inspection phase start.
    Loading tablespace files.
    Inspecting next tablespace and associated containers.
    Inspecting next tablespace and associated containers.
    Inspecting next tablespace and associated containers.
    3 tablespaces were identified and their containers checked.
    Tablespace file inspection phase end.


    SYSBOOT inspection phase start.

    Data inspection phase start. Data obj: 1 In pool: 0
    Data inspection phase end.

    SYSBOOT inspection phase end.


    SYSTABLES inspection phase start.

    Data inspection phase start. Data obj: 2 In pool: 0
    Data inspection phase end.

    SYSTABLES inspection phase end.


    Bufferpool file report phase start.
    1 bufferpools were identified.
    Bufferpool file report phase end.


    Tablespace inspection phase start. Pool: 0

    Tablespace-info inspection phase start.
    Tablespace-info inspection phase end.

    Table inspection start: SYSIBM.SYSTABLES

    Data inspection phase start. Data obj: 2 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 2 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for unique index itoken(5) root page:6p.
    Scanning pages for index itoken(6) root page:7p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 2 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLUMNS

    Data inspection phase start. Data obj: 3 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 3 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXES

    Data inspection phase start. Data obj: 4 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 4 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 4 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSVIEWS

    Data inspection phase start. Data obj: 7 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 7 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 7 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSVIEWDEP

    Data inspection phase start. Data obj: 8 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 8 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPLAN

    Data inspection phase start. Data obj: 9 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 9 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for unique index itoken(3) root page:4p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 9 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPLANDEP

    Data inspection phase start. Data obj: 10 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 10 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 10 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSECTION

    Data inspection phase start. Data obj: 11 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 11 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 11 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSTMT

    Data inspection phase start. Data obj: 12 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 12 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 12 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSDBAUTH

    Data inspection phase start. Data obj: 13 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 13 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPLANAUTH

    Data inspection phase start. Data obj: 14 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 14 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTABAUTH

    Data inspection phase start. Data obj: 15 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 15 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXAUTH

    Data inspection phase start. Data obj: 16 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 16 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSRELS

    Data inspection phase start. Data obj: 17 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 17 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSROUTINES

    Data inspection phase start. Data obj: 18 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 18 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for unique index itoken(5) root page:6p.
    Scanning pages for unique index itoken(6) root page:7p.
    Scanning pages for unique index itoken(7) root page:8p.
    Scanning pages for unique index itoken(8) root page:9p.
    Scanning pages for index itoken(9) root page:10p.
    Scanning pages for index itoken(10) root page:11p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 18 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSROUTINEPARMS

    Data inspection phase start. Data obj: 19 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 19 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for index itoken(5) root page:6p.
    Scanning pages for unique index itoken(6) root page:7p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTABCONST

    Data inspection phase start. Data obj: 20 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 20 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSKEYCOLUSE

    Data inspection phase start. Data obj: 21 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 21 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCHECKS

    Data inspection phase start. Data obj: 22 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 22 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 22 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLCHECKS

    Data inspection phase start. Data obj: 23 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 23 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSDATATYPES

    Data inspection phase start. Data obj: 24 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 24 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Scanning pages for unique index itoken(3) root page:4p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 24 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCONSTDEP

    Data inspection phase start. Data obj: 25 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 25 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLDIST

    Data inspection phase start. Data obj: 26 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 26 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSEVENTMONITORS

    Data inspection phase start. Data obj: 27 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 27 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 27 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSEVENTS

    Data inspection phase start. Data obj: 28 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 28 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 28 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTABLESPACES

    Data inspection phase start. Data obj: 29 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 29 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for unique index itoken(4) root page:5p.
    Scanning pages for index itoken(5) root page:6p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSDEPENDENCIES

    Data inspection phase start. Data obj: 30 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 30 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTRIGGERS

    Data inspection phase start. Data obj: 31 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 31 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 31 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLAUTH

    Data inspection phase start. Data obj: 32 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 32 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSCHEMAAUTH

    Data inspection phase start. Data obj: 33 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 33 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSCHEMATA

    Data inspection phase start. Data obj: 34 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 34 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSUSERAUTH

    Data inspection phase start. Data obj: 35 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 35 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 35 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSNODEGROUPDEF

    Data inspection phase start. Data obj: 36 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 36 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSNODEGROUPS

    Data inspection phase start. Data obj: 37 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 37 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPARTITIONMAPS

    Data inspection phase start. Data obj: 38 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 38 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    Long Field inspection phase start. Long Field obj: 38 In
    pool: 0
    Long Field inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSBUFFERPOOLS

    Data inspection phase start. Data obj: 39 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 39 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSBUFFERPOOLNODES

    Data inspection phase start. Data obj: 40 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 40 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLPROPERTIES

    Data inspection phase start. Data obj: 5 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 5 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSATTRIBUTES

    Data inspection phase start. Data obj: 41 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 41 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSHIERARCHIES

    Data inspection phase start. Data obj: 42 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 42 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTBSPACEAUTH

    Data inspection phase start. Data obj: 43 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 43 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLOPTIONS

    Data inspection phase start. Data obj: 44 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 44 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSFUNCMAPOPTIONS

    Data inspection phase start. Data obj: 45 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 45 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSFUNCMAPPARMOPTIONS

    Data inspection phase start. Data obj: 46 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 46 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSFUNCMAPPINGS

    Data inspection phase start. Data obj: 47 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 47 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for index itoken(5) root page:6p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXEXPLOITRULES

    Data inspection phase start. Data obj: 48 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 48 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXEXTENSIONPARMS

    Data inspection phase start. Data obj: 49 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 49 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXEXTENSIONS

    Data inspection phase start. Data obj: 50 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 50 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 50 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXEXTENSIONMETHODS

    Data inspection phase start. Data obj: 51 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 51 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXOPTIONS

    Data inspection phase start. Data obj: 52 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 52 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPASSTHRUAUTH

    Data inspection phase start. Data obj: 53 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 53 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPREDICATESPECS

    Data inspection phase start. Data obj: 54 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 54 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 54 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPROCOPTIONS

    Data inspection phase start. Data obj: 55 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 55 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSPROCPARMOPTIONS

    Data inspection phase start. Data obj: 56 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 56 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTYPEMAPPINGS

    Data inspection phase start. Data obj: 57 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 57 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for index itoken(5) root page:6p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSERVEROPTIONS

    Data inspection phase start. Data obj: 58 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 58 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for unique index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSERVERS

    Data inspection phase start. Data obj: 59 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 59 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 59 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTABOPTIONS

    Data inspection phase start. Data obj: 60 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 60 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSTRANSFORMS

    Data inspection phase start. Data obj: 61 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 61 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSUSEROPTIONS

    Data inspection phase start. Data obj: 62 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 62 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSWRAPOPTIONS

    Data inspection phase start. Data obj: 63 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 63 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSWRAPPERS

    Data inspection phase start. Data obj: 64 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 64 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSJARCONTENTS

    Data inspection phase start. Data obj: 65 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 65 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 65 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSJAROBJECTS

    Data inspection phase start. Data obj: 66 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 66 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 66 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSNAMEMAPPINGS

    Data inspection phase start. Data obj: 67 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 67 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSEQUENCES

    Data inspection phase start. Data obj: 68 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 68 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 68 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSINDEXCOLUSE

    Data inspection phase start. Data obj: 6 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 6 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSVERSIONS

    Data inspection phase start. Data obj: 69 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 69 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLUSE

    Data inspection phase start. Data obj: 70 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 70 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSROUTINEAUTH

    Data inspection phase start. Data obj: 71 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 71 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Scanning pages for index itoken(5) root page:6p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSLIBRARIES

    Data inspection phase start. Data obj: 72 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 72 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSLIBRARYBINDFILES

    Data inspection phase start. Data obj: 73 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 73 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 73 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSLIBRARYVERSIONS

    Data inspection phase start. Data obj: 74 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 74 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 74 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLGROUPS

    Data inspection phase start. Data obj: 75 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 75 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLGROUPSCOLS

    Data inspection phase start. Data obj: 76 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 76 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLGROUPDIST

    Data inspection phase start. Data obj: 77 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 77 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOLGROUPDISTCOUNTS

    Data inspection phase start. Data obj: 78 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 78 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSLIBRARYAUTH

    Data inspection phase start. Data obj: 79 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 79 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSEVENTTABLES

    Data inspection phase start. Data obj: 80 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 80 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for unique index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSROUTINEPROPERTIESJAVA

    Data inspection phase start. Data obj: 81 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 81 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCOMMENTS

    Data inspection phase start. Data obj: 82 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 82 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSSEQUENCEAUTH

    Data inspection phase start. Data obj: 83 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 83 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSCODEPROPERTIES

    Data inspection phase start. Data obj: 84 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 84 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 84 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTS

    Data inspection phase start. Data obj: 85 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 85 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTPROPERTIES

    Data inspection phase start. Data obj: 86 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 86 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLRELATIONSHIPS

    Data inspection phase start. Data obj: 87 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 87 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLRSPROPERTIES

    Data inspection phase start. Data obj: 88 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 88 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLPHYSICALCOLLECTIONS

    Data inspection phase start. Data obj: 89 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 89 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Scanning pages for index itoken(3) root page:4p.
    Scanning pages for index itoken(4) root page:5p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTAUTH

    Data inspection phase start. Data obj: 90 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 90 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Scanning pages for index itoken(2) root page:3p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTAUTHPERF

    Data inspection phase start. Data obj: 91 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 91 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 91 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTRELDEP

    Data inspection phase start. Data obj: 92 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 92 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLOBJECTXMLDEP

    Data inspection phase start. Data obj: 93 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 93 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLSTATS

    Data inspection phase start. Data obj: 94 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 94 In pool: 0
    Scanning pages for index itoken(1) root page:2p.
    Index inspection phase end.

    Table inspection end.

    Table inspection start: SYSIBM.SYSXMLQUERIES

    Data inspection phase start. Data obj: 95 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 95 In pool: 0
    Scanning pages for unique index itoken(1) root page:2p.
    Index inspection phase end.


    LOB inspection phase start. LOB obj: 95 In pool: 0
    LOB inspection phase end.

    Table inspection end.

    Tablespace inspection phase end.


    Tablespace inspection phase start. Pool: 1
    This is a temporary table space. Nothing to inspect.
    Tablespace inspection phase end.


    Tablespace inspection phase start. Pool: 2

    Tablespace-info inspection phase start.
    Tablespace-info inspection phase end.

    Table inspection start: DB2ADMIN.ActionsT

    Data inspection phase start. Data obj: 2 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.AssIndCollT

    Data inspection phase start. Data obj: 3 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.bareme

    Data inspection phase start. Data obj: 4 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.caisse

    Data inspection phase start. Data obj: 5 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.CaisseAttaque

    Data inspection phase start. Data obj: 6 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.CaissesConcurrentesT

    Data inspection phase start. Data obj: 7 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.canton

    Data inspection phase start. Data obj: 8 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.CouvertureT

    Data inspection phase start. Data obj: 9 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.critere

    Data inspection phase start. Data obj: 10 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.FrequenceFacturesT

    Data inspection phase start. Data obj: 11 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.libelle

    Data inspection phase start. Data obj: 12 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.localite

    Data inspection phase start. Data obj: 13 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.ModePaiementT

    Data inspection phase start. Data obj: 14 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.NationaliteT

    Data inspection phase start. Data obj: 15 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.PermisT

    Data inspection phase start. Data obj: 16 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.reg_comm AH

    Data inspection phase start. Data obj: 17 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.StatutT

    Data inspection phase start. Data obj: 18 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.TitelsT

    Data inspection phase start. Data obj: 19 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.TypeAdhesionT

    Data inspection phase start. Data obj: 20 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Table inspection start: DB2ADMIN.TypeRenteT

    Data inspection phase start. Data obj: 21 In pool: 2
    Data inspection phase end.

    Table inspection end.

    Tablespace inspection phase end.

    Database inspection phase end.

    ______________________________________

    The requested DB2DART processing has completed successfully!
    All operation completed without error;
    no problems were detected in the database.
    ______________________________________

    Complete DB2DART report found in:
    C:\PROGRA~1\IBM\SQLLIB\DB2\DART0000\RATE2003.RPT

    _______ D A R T P R O C E S S I N G C O M P L E T E
    _______
    Gianfranco Guest

  2. #2

    Default Re: SQL1034C error when creating stored procedure

    The -1224 error tells us that the instance failed during the
    command...you should see a .trp file in your db2dump directory...try
    formatting it with db2xprt, and posting it here, along with the output
    of "db2level".

    Gianfranco wrote: 

    Sean Guest

  3. #3

    Default Re: SQL1034C error when creating stored procedure

    Hi Sean,

    thanks for your help but I haven't got a .trp file. I've made a search
    in all my C Disk but no-one file were found.

    Have you got one othe idea?

    Thanks

    Gianfranco



    Sean McKeough <ca.ibm.com> wrote in message news:<bm110p$ia5$torolab.ibm.com>... [/ref]
    Gianfranco Guest

Similar Threads

  1. Oracle Stored procedure error from CF
    By peace4theapes in forum Coldfusion Database Access
    Replies: 13
    Last Post: November 16th, 11:28 PM
  2. Stored procedure error
    By HariMaki in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: December 3rd, 12:59 PM
  3. C stored procedure SQL error.
    By Craig in forum IBM DB2
    Replies: 2
    Last Post: July 11th, 04:44 PM
  4. Stored Procedure Servers Error
    By Adam Campbell in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 02:03 PM
  5. Creating a trigger that calls a stored procedure
    By Elie in forum Oracle Server
    Replies: 2
    Last Post: December 29th, 06:13 AM

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