Tag Archives: db2

PHP & Postgres

I have been using PHP for a while now.  When people say PHP, its usually associated with     MySQL as its backend database. But PHP will work with pretty much any database.  Few years ago I wrote about how … Continue reading

Posted in Applications, database, db2, how to | Tagged , , , , , , , , , | Leave a comment

Gotcha when restoring database with restrictive access !

Starting from DB2 V9.1, IBM added a parameter on the CREATE DATABASE command called RESTRICTIVE.   When this parameter is specified nobody other than the userid creating the database gets any implicit access to the database.  The database is automatically … Continue reading

Posted in database, db2, how to | Tagged , , , , , | Leave a comment

Stored Proc for SQL Server and DB2 UDB

We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables.  Just for the … Continue reading

Posted in database, db2, sql server | Tagged , , , , , , , , , | Leave a comment

Loading db2 tables from another database

Data movement is a common task that app dev and dbas perform often. DB2 has multiple options to mass add data to tables : IMPORT, LOAD and DB2MOVE.  Each of them have its own pros and cons.  If you are … Continue reading

Posted in db2, how to | Tagged , , , , , , , , , , | Leave a comment