USER_EXIT

[memonsa]

I am fairly new to DB2 world.
I am trying to set up a user exit db2uext2.cdisk. I copied/compiled/linked it and the executable is now in SQLLIB\bin. I want ot use all the defaults and hence I have not changed any thing in db2uext2.cdisk.
I created c:\mylogs.
I am making few changes in my SAMPLE db and then COMMIT/ DISCONNECT to force the log to close. I connect to SAMPLE again. Per my understanding, at this point the user_exit should be called and the logs should be archived ( I have user_exit = yes and logretain = RECOVERY). I also have AUDIT_ACTIVE and ERROR_ACTIVE.
I donot see ARCHIVE.LOG or USEREXIT.ERR. My db2diag.log shows the following-
"User Exit returned error when archiving log file S0000004.LOG from C:\DB2\NODE0000\SQL00002\SQLOGDIR\ for database SAMPLE, error code 28"

Please guide me.
Thanks.

 

[matchum]

Presumably you are using UDB 7.2 ?

What is the DIAGLEVEL set to ? (it may pay to temporarily bump this up to improve the diagnostics you are getting in db2diag.log).

Where is your DIAGPATH pointing to ?

7.2 also introduced the "ARCHIVE LOG" command - does this have the same effect ? If so, the fault presumably lies with the user-exit itself .

 

[memonsa]

I resolved it, thanks.

 

[yarnseeker]

What was the resolution?

 

[matchum]

memonsa,

Quick question for you:

What is the syntax of your backup command (how do you 'prove' your exit-rtn) ?

Reason:
One of our UDB V7.1 machines has had a TSM upgrade but (as far as I can see) nothing has changed within the UDB CFG yet the backup is only copying the D/b and NOT the logs.
Userexit is set to YES, logretain to RECOVERT