| Author |
Message |
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
 SQL0440N Error on Set Data Audit Options |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
On which type of system the DB2 server is running?
|
|
| Mon Jul 19, 2010 4:05 pm |
|
|
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
| I am testing on a local testbed, not our Server |
|
I am running Windows XP SP3.
|
|
| Mon Jul 19, 2010 4:15 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
| Your Right! |
|
DB2 8.1.15 is our current Production version. Sorry for the confusion.
|
|
| Tue Jul 20, 2010 10:16 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
| |
|
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 |
|
|
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Thank you for the status update. I'm glad that the found solution worked well for you.
|
|
| Mon Jul 26, 2010 3:55 pm |
|
|
dmorris
Joined: 19 Jul 2010
Posts: 6
Country: United States |
|
| |
|
Thanks for the GREAT support! Sure is good to see a responsive Support site!
|
|
| Mon Jul 26, 2010 4:10 pm |
|
|
|
