Tag: IBM

Community

Asked & Answered

(Roger Miller) We require the ability to provide DBAs access to a database in RW or RO mode for maintenance purposes while leaving it unavailable to the end users (applications). The UT mode doesn’t allow us to perform the maintenance we require.

Community

Cost-based optimization in DB2 XML

(A. Balmin, T. Eliaz, J. Hornibrook, L. Lim, G. M. Lohman, D. Simmen, M. Wang and C. Zhang) DB2 XML is a hybrid database system that combines the relational capabilities of DB2 Universal Database (UDB) with comprehensive native XML support. DB2 XML augments DB2 UDB with a native XML store, XML index

Community

Copy Schema in DB2 9

(Chris Eaton) Ever wanted to copy all of the objects in one schema over to another schema name? DB2 9 lets you do that now with one command. There is now a new stored procedure called ADMIN_COPY_SCHEMA that can duplicate all of the objects (tables, indexes, views, MQTs, functions, etc) from one sche