Topic
  • 3 replies
  • Latest Post - ‏2013-08-27T21:32:30Z by mccormik
tsaijoen
tsaijoen
4 Posts

Pinned topic tbsm_db.sh script errors

‏2013-08-15T08:05:44Z |

Several errors during creation of the schema: script tbsm_db.sh

 

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0454N  The signature provided in the definition for routine
"TBSMUDF.REGEXFORMATREPLACEALL_C" matches the signature of some other routine.
LINE NUMBER=3.  SQLSTATE=42723

 

Regards Tjeerd
 

  • mccormik
    mccormik
    2 Posts

    Re: tbsm_db.sh script errors

    ‏2013-08-26T21:03:52Z  

    Hi Tjeerd,

    Is this a new database that is being created or was the database previously created?  The SQLState indicates that a UDF function with that signature already exists.  In the tbsmdb/logs directory you should have the file, db2_stdout.log, could you attach that file?

    thanks,   Karl

  • tsaijoen
    tsaijoen
    4 Posts

    Re: tbsm_db.sh script errors

    ‏2013-08-27T12:06:46Z  
    • mccormik
    • ‏2013-08-26T21:03:52Z

    Hi Tjeerd,

    Is this a new database that is being created or was the database previously created?  The SQLState indicates that a UDF function with that signature already exists.  In the tbsmdb/logs directory you should have the file, db2_stdout.log, could you attach that file?

    thanks,   Karl

    Karl it is possible that they did not uninstall db2 correct and that their was some left overs, I can not check this anymore because our IT department needed the box and have installed tivoli smartcloud control desk for a poc of a customer on this.

     

    Regards Tjeerd

  • mccormik
    mccormik
    2 Posts

    Re: tbsm_db.sh script errors

    ‏2013-08-27T21:32:30Z  
    • tsaijoen
    • ‏2013-08-27T12:06:46Z

    Karl it is possible that they did not uninstall db2 correct and that their was some left overs, I can not check this anymore because our IT department needed the box and have installed tivoli smartcloud control desk for a poc of a customer on this.

     

    Regards Tjeerd

    Hi Tjeerd,

    If the database already existed, then all of the create function statements should have returned SQLSTATE=42723.  If you get the box back and this reoccurs please attach the db2_stdout.log and we will take a look.

    thanks, Karl