Auditing is a two way street. When you audit you are trying to verify tha somebody is following all of the rules that have been established.
So if you want to audit somebody you need to first find the rules they should be following and then find out (from them?) how they are complying with those requirments.
I would think that what you are looking for would not be something this forum can provide you.
Rus...
reharpernc
Last Activity: Oct 23 '07, 12:30 PM
Joined: Oct 17 '06
Location: Lewisville, NC
-
It would hep if you explain what the problem was (like error messages).
I export to del format everyday - so it does work.
RussLeave a comment:
-
IBM has a wonderful site called developersworks that has lots of free stuff for DB2 (and other things too).
They have free tutorials for all of the certification exams for v8 and v9.
700 DB2 Fundamentals (v8)
701 DB2 DBA (v8)
703 DBA Application Development (v8)
730 DB2 Fundamentals (v9)
731 DB2 DBA (v9)
Registration is required - but is free.
RussLeave a comment:
-
Have you looked in sqllib/db2dump/db2diag.log to see what DB2 is complaining about?Leave a comment:
-
Primary keys are never required in DB2.
The only thing that a "primary key" clause gives you is that DB2 will create a unique index to support the unique rule specified in the primary key clause.
You could do the same by defining your own unique index (without using the "primary key" clause).
Or, as your question asks, you can create any table (temporary or otherwise) without indexes....Leave a comment:
No activity results to display
Leave a comment: