Forgot your password?
Document Actions
ADM1832E error got ????
Up to DB2
Posted by
I am getting this error in notification file.
What meaning of this error and how to resolve it...Please reply ASAP
ADM1832E DB2 was unable to find the user exit program when archiving log file
"S0000011.LOG" from "/home/db/db/NODE0000/SQL00001/SQLOGDIR/" for
database "db". The error code was "24".
and one more message is getting
"Still unable to archive log file 11 due to rc 24 for LOGARCHMETH1 using method 4 and target ."
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/carsdb2/carsdb2/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000027.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Percent of max active log space by transaction(MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
First log archive method (LOGARCHMETH1) = USEREXIT
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Thanks & Regards
Pawan
In your case, you are using USEREXIT to archive the logs "First log archive method (LOGARCHMETH1) = USEREXIT".
To configure the USEREXIT parameters, you need to set correctly the file db2uext2.
If you need some examples this kind of file, please check the sample files in the directory below:
sqllib/samples/c
There are four sample user exit programs for UNIX based systems:
- db2uext2.ctsm
This sample uses Tivoli® Storage Manager
to archive and retrieve database log files. - db2uext2.ctape
This sample uses tape media
to archive and retrieve database log files . - db2uext2.cdisk
This sample uses the operating
system COPY command and disk media to archive and retrieve database log files. - db2uxt2.cxbsa
This sample works with the XBSA Draft 0.8 published by the X/Open group.
It can be used to archive and retrieve database log files. This sample is
only supported on AIX®.
There are two sample user exit programs for Windows operating systems:
- db2uext2.ctsm
This sample uses Tivoli Storage Manager
to archive and retrieve database log files. - db2uext2.cdisk
This sample uses the operating
system COPY command and disk media to archive and retrieve database log files.
More details: http://www.dbatodba.com/db2/how-to-do/setting-up-a-user-exit
Hacker Rangers - Gamification for CyberSecurity