SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL0440N Error on Set Data Audit Options

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
SQL0440N Error on Set Data Audit Options
Author Message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post SQL0440N Error on Set Data Audit Options Reply with quote
Just installed DB Audit 4.2 for DB2 using version 9.2 of DB2 and get this error on the Set Data Audit Options when defining specific columns on one table.

Thanks,
Don



Mon Jul 19, 2010 3:52 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
On which type of system the DB2 server is running?
Mon Jul 19, 2010 4:05 pm View user's profile Send private message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post I am testing on a local testbed, not our Server Reply with quote
I am running Windows XP SP3.
Mon Jul 19, 2010 4:15 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
There is no such version 9.2 for DB2 UDB for Windows. Please check you are not confusing your DB2 client version and your DB2 server version,

Please run db2level command on your DB2 server to find out the actual version and fix pack level.
Mon Jul 19, 2010 7:23 pm View user's profile Send private message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post Your Right! Reply with quote
DB2 8.1.15 is our current Production version. Sorry for the confusion.
Tue Jul 20, 2010 10:16 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Hi,

We checked several versions of DB Audit. None of them are using APPLICATION_ID function for the system auditing. This function is only used for the data-change auditing and only in case the DB2 server version is supposed to support that function.

Where exactly do you get this error?

By the way, here is what we found out about APPLICATION() function availability in DB2 8.1. Please see IBM's document "Need to run db2updv8 if UDFs GET_DBM_CONFIG and APPLICATION_ID are not defined" which should help you to resolve the issue http://www.ibm.com/support/docview.wss?rs=71&uid=swg21221547
Mon Jul 26, 2010 9:00 am View user's profile Send private message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post Reply with quote
I get this error in Set Data Audit Options when I set any Table to be Auditted and click Proceed. I displays immediately on clicking PROCEED.

Mon Jul 26, 2010 9:38 am View user's profile Send private message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post Reply with quote
Wanted to let you know that the link you provided had the information I needed to resolve the problem and was able to apply Triggers!

Thanks very much!
Mon Jul 26, 2010 9:42 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Thanks. So that is not a system auditing method as you indicated in the previous post, it is a data-change auditing method. Please follow instructions provided in the referenced IBM document to get your database server patched. This should resolve the issue.
Mon Jul 26, 2010 9:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Thank you for the status update. I'm glad that the found solution worked well for you.
Mon Jul 26, 2010 3:55 pm View user's profile Send private message
dmorris



Joined: 19 Jul 2010
Posts: 6
Country: United States

Post Reply with quote
Thanks for the GREAT support! Sure is good to see a responsive Support site!
Mon Jul 26, 2010 4:10 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.