Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

Troubleshooting SQL2219N and reason code 9

Mar 23 2012 12:00AM by Jack Vamvas   

This DB2 error message SQL2219N  reason code 9 appeared in the db2 db2diag file. 

The DB2 documentation details for reason code 9 are “START is not allowed as a prior paused table reorganization has not been stopped”.

I discovered there was a scheduled maintenance of the databases – 1) REORG - managing reorg of tables  (and indexes).  2) RUNSTATS

It conflicted with the AUTO_REORG  on the databases. Turning off AUTO_REORG stopped the error occurring.

2012-03-18-22.49.37.393468+000 E2273446E603        LEVEL: Error
PID     : 25077                TID  : 189054052704 PROC : db2sysc
INSTANCE: db2tdw               NODE : 000          DB   :MYDB
APPHDL  : 0-17413              APPID: *LOCAL.db2tdw.120319003038
AUTHID  : DB2JV  
EDUID   : 82                   EDUNAME: db2agent (MYDB)
FUNCTION: DB2 UDB, data management, sqldOLRValidate, probe:100
MESSAGE : ADM5590E  The specified INPLACE table reorganization action on table 
          "DB2JV .DATA_DETAILS" is not allowed on this node because of 
          SQLCODE -2219 reason code "9".

 


Republished from SQL Server DBA [65 clicks].  Read the original version here [7 clicks].

Jack Vamvas
5 · 26% · 8528
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Troubleshooting SQL2219N and reason code 9 " rated 5 out of 5 by 1 readers
Troubleshooting SQL2219N and reason code 9 , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]