Latelty I had to play around with Content Manager and DB2 as the database software.
DB2 is really nice, although it is annoying as backspace is not working in my environment. God knows why, I honestly did not care.
Stuff that i stumbled accross were some nice DB2 tasks to update many rows at once with a tool called “db2batch”.
The usage within DB2 is a bit odd for me:
Update rmobjects set obj_stgclassid=12 where obj_itemid=’OB123asdSD23′ where obj_mgtclassid=12
What really annoyed me on this syntax is the fact, that the obj_itemid had to be in ‘ ‘. The other values did not need this.
For the db2batch you use following syntax to start it:
db2batch -d <databasename> -f /<filename> -a <user>/<password> -r /<filenameforresults>
It will, if the SQL statement is correct, do the stuff that is in <filename>.
You can check the result in <filenameforresults>.
If you need to change anything within DB2 and the setup is made by ContentManager first do “db2 list command options” to check if autocommit is switched on.