Jderrick: Added more errors related to ADM1822W - IBM CMOD ARS0238 and IBM CMOD ARS0013E.

2017-02-13T14:55:34Z

Added more errors related to ADM1822W - IBM CMOD ARS0238 and IBM CMOD ARS0013E.

← Older revision		Revision as of 14:55, 13 February 2017
Line 22:		Line 22:

	== Related Errors ==		== Related Errors ==
			[[ARS0238W]] [[ARS0013E]]

	== What were you doing? ==		== What were you doing? ==

Jderrick: Fixed the formatting for ADW1822.

2017-02-12T02:45:20Z

Fixed the formatting for ADW1822.

← Older revision		Revision as of 02:45, 12 February 2017
Line 2:		Line 2:
	== What was the error? ==		== What was the error? ==
	'''Message Number''': 1822		'''Message Number''': 1822
	~~The active transaction log is being held by dirty pages. Database performance may be impacted.~~

	'''Message Severity''': Warning (An error was returned, but no corrective action is required to proceed.)		'''Message Severity''': Warning (An error was returned, but no corrective action is required to proceed.)

Jderrick: Initial Edit - how to fix ADM1822W in IBM CMOD.

2017-02-12T02:44:41Z

Initial Edit - how to fix ADM1822W in IBM CMOD.

New page

{{TOCright}}
== What was the error? ==
'''Message Number''': 1822
The active transaction log is being held by dirty pages. Database performance may be impacted.

'''Message Severity''': Warning (An error was returned, but no corrective action is required to proceed.)

'''Message Name''': ADM1822W

'''Message Text''': The active transaction log is being held by dirty pages. Database performance may be impacted.

== Example ==

2017-02-11-02.12.53.472789-360 E5407246A578 LEVEL: Warning
PID : 13369466 TID : 2995 PROC : db2sysc 0
INSTANCE: archive NODE : 000 DB : ARCHIVE
APPHDL : 0-322 APPID: *LOCAL.archive.170211074159
AUTHID : ARCHIVE HOSTNAME: ibmcmod
EDUID : 2995 EDUNAME: db2agent (ARCHIVE) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteToLog, probe:1660
MESSAGE : ADM1822W The active transaction log is being held by dirty pages.
Database performance may be impacted.

== Related Errors ==

== What were you doing? ==
Probably loading data with the IBM CMOD arsload command, or expiring documents with the IBM CMOD arsmaint utility.

== What happened? ==
The action you were trying to do failed, because there wasn't enough room in the database transaction logs to record the transaction. If you were loading data into IBM Content Manager OnDemand using arsload, the file may contain more documents than the transaction logs have room for.

This error is common if you encountered errors configuring the Content Manager OnDemand database with the IBM CMOD arsdb command in OnDemand V8.5.

== Troubleshooting ==
This is a DB2 error message, so you should find the db2diag.log (located in ~/sqllib/db2dump) and look for error messages around the same time.

This message indicates that you don't have enough transaction log space. You can increase either the number of transaction log files by increasing the LOGPRIMARY DB2 database configuration parameter, or the size of each individual transaction log by increasing the LOGFILSIZ parameter.

If the limitation is the filesystem where your transaction logs are stored (/arsdb/arsdb_primarylog) then you may either increase the size of that filesystem, or move the logs to another location using the NEWLOGPATH configuration parameter.

If you feel that you have enough transaction logs defined, you may want to adjust the NUM_IOCLEANERS parameter upwards to increase the number of processes that clean the 'dirty' transaction log files.

Finally, you may want to add archive logging by configuring the LOGARCHMETH1 parameter, and enabling transaction log compression with LOGARCHCOMPR1.

The links below give more information on how to change these configuration parameters. If you are unfamiliar with tuning DB2, contact your local Database Administrator for assistance.

== Articles Related to this message ==
[http://www.odusergroup.org/forums/index.php?topic=955.0 IBM Content Manager OnDemand User Group - SQL0964C]

[https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/t0021274.html Configuring DB2 Database Logging Options for DB2 v10.5]

[https://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.ha.doc/doc/t0021274.html Configuring DB2 Database Logging Options for DB2 v10.1]

[https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.ha.doc/doc/t0021274.html Configuring DB2 Database Logging Options for DB2 v9.7]

ADM1822W - Revision history

Jderrick: Added more errors related to ADM1822W - IBM CMOD ARS0238 and IBM CMOD ARS0013E.

Jderrick: Fixed the formatting for ADW1822.

Jderrick: Initial Edit - how to fix ADM1822W in IBM CMOD.