DB2 upgrade from 9.1 to 10.1

[Former Member]

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

[MarcinOzdzinski · Accepted solution]

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 ?

[Former Member · Accepted solution]

Thanks for reply.

I followed these steps for upgrade database

1.  installed DB software  from               /<DVD_mount>/LINUXX86_64/ESE/disk1/db2setup

2.  Check migration command for possibility of db2 update by

  /db2/dbSID/db2v10.1/instance/db2ckupgrade –e –l db2upgrade.log

3. Take database backup configuration

4. Upgrade Instance

     go to software installed directory

    and run command ./db2iupgrade –u db2SID db2SID

5.  db2 upgrade database SID

6.  Upgrade DB2 License

7.  Upgrade Client Driver

      goto Db6 client software   <mount_DVD_Dir>/CLIENT

     ./db6_update_client.sh –u

Marcin  how where to run  db6update script with option -d and -m

Kindly guide me what I done wrong in above upgrade steps

Regards

[MarcinOzdzinski · Accepted solution]

Check page 45 in upgrade guide for 10.1 and note :

http://service.sap.com/sap/support/notes/1365982

[Former Member · Accepted solution]

Thanks Marcin I miss db6_update_db.sh  -m –d <DBSID>

when I run this process warning messages no more appear thankx a lot for you help

any tips for performance and tuning becuse our database almost 1 TB and some times it very slow down and in st04 buff pool ----  Average time --- physical read goes to 350

who can I tune it

need your help

Regards

[MarcinOzdzinski · Accepted solution]

Glad to hear it helped you.

Avarage read time could be decreased  by compressing your largest tables - use ADAPTIVE compression available from 10.1 version  and online ADMIN_MOVE_TABLE under DB6CONV report (search notes for documantation).

[Former Member · Accepted solution]

Hi Dear All

I need to upgrade db2 9.1 to 9.7 in my Solman server on windows 2008. So Could you please let me know the Process to upgrade the db2 .

Thanks-

Gaurav

[andreas_herzog · Accepted solution]

the procedure is basically the same as described above by shahid ranazai  (step 1-7)...pls start with thoroughly reading the upgrade guide + according sapnotes:

- https://websmp104.sap-ag.de/instguides and then navigate to DB Upgrades -> DB2 UDB -> "Upgrade to Version 9.7 of IBM DB2 for LUW"

- SAPNote 1332109

GreetZ, AH

[Sriram2009]

Hi

Kindly refer the SAP Note and some of the IBM links

1701785 - DB6: REORG job for compressing tables terminates

DB2 Database for Linux, UNIX, and Windows

http://www-01.ibm.com/support/docview.wss?uid=swg21639148

Regards

Sriram