I have created views on the database (create a library of mine, separate of the production library) and once every two weeks my views (not all of them, about 50% out of all) get deleted. I was thinking of a trigger (before delete on LIBRARY) but i have found DB400 does triggers only on tables/views (DB2ROW or DB2SQL).
Bottom line, i want to see who is deleting my views. How can i get this accomplished?
If your views reference IBM-provided views in QSYS2 or SYSIBM, then sometimes those IBM-provided views get rebuilt during the installation of a Database Group PTF or new release.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.