Skip to Content
author's profile photo Former Member
Former Member

DB2 upgrade from 9.1 to 10.1

Dear Experts

I am upgrade our db2 databse from 9.1 to 10.1 ( first 9.1 to 9.7 then 9.7 to 10.1)

with some warning

and

alter_unfenced_PRD.ls

Beginning in DB2 Version 9.5, the database manager is now multi-threaded on UNIX and Linux platforms. To prevent potential problems that can occur due to the execution of thread unsafe code, all external NOT FENCED objects will be altered to FENCED during the database migration.

The following is a list of all the affected external unfenced routines which do not have the dependency on the engine libraries in database 'PRD'. During the database migration these routines will be altered to FENCED and NOT THREADSAFE.

-------------------------------------------------

ROUTINESCHEMA.ROUTINENAME SPECIFICNAME

-------------------------------------------------

SAPTOOLS.INSPECT_REMOVE_DAT_FILE ( INSPECT_REMOVE_DAT_FILE )

when I run dbacockpit transaction following warning appear

and reorg schema SAPTOOLS then following error

Reorg_Table: Database: +++DB6ADM

Reorg_Table:caused by

Reorg_Table:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

Reorg_Table: Kernel Error ID:

Reorg_Table: DB Error: Yes

Reorg_Table: SQL Code: 668-

Reorg_Table: SQL Message: SQL0668N Operation not allowed forreason code "7" on

Reorg_Table: table "SAPTOOLS.DBH_STG_INDEX". SQLSTATE=57016

Reorg_Table: DB Object Exists: No

Reorg_Table: Duplicated Key: No

Reorg_Table: Internal Error: 1

Reorg_Table: Invalid Cursor: No

Reorg_Table: Unknown Connection: No

Reorg_Table: Connection Closed: No

Exception CX_DBA_JOB in class CL_DB6_RDI_TABLE method line 112

Reorg_Table:terminated with error

REASON=ADBC error

Job finished

Need help

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 21, 2014 at 01:51 PM

    Did you run latest version of db6update script with options -d -m after finished db2 upgrade db PRD command ?

    If yes were there any warnings and errors in log file ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 21, 2014 at 11:32 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.