Follow me !
By PDGACO gaballaloans.co.uk
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
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 bitmani, connect php to postgres, db2, pg_connect, pg_query, php, php and postgres, php5-pgsql, postgres, psql
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
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 db2, dynamic sql, execute, grant, loop, sp_executeSQL, SQL Server, SQL/PL, stored procedure, T-SQL
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 data movement, db2, db2 import, db2 load, db2 load from cursor, db2move, export, fast and easy load, load, load from cursor, loading data from another table
Leave a comment