'DB2' Category

  • The Whole Package Cache – Podcast!

    March 25, 2014

    Listen to DB2 experts Ian Bjorhovde and Fred Sobotka chat about what’s new in the world of DB2. pkgcache.com Its entertaining and informative!

  • RAHTREETHRESH and Permission denied errors

    February 5, 2014

    On our DPF environment(DB2 10.1 on Linux) with 195 partitions, non-instance owner userid’s would receive permission denied errors for RAH & db2_all commands. Permission denied (gssapi-keyex,gssapi-with-mic,publickey,keyboard-interactive). DB2RSHCMD has been set to SSH, and I did have SSH configured to access without password. An SSH into the host would succeed without a password prompt or any […]

  • Poor Performance On Just One Node

    January 12, 2014

    Just the LOAD node in the DPF cluster, which is used by the batch jobs to perform LOAD’s was slow compared to the other servers Connects to the database would take over 50secs (Other servers under a second) Queries were running for over 50Secs while the same query will be back in couple of seconds […]

  • FCM AUTOMATIC setting isn’t fast enough?

    October 8, 2013

    ENVIRONMENT: DB2 v10.1 FP 2 OS: RHEL 6.4 PROBLEM: On one of our DPF environment, we noticed a resource intensive job failed exhausting both the FCM Buffers & channels. Would see the following entries in the db2diag.log and also errors about “No FCM Buffer Available” 2013-10-03-05.49.47.787008-300 I518288292E547 LEVEL: Error PID : 8369 TID : 46968990590720 […]

  • Record count doesn’t match the CARD in SYSCAT.TABLES

    January 22, 2007

    Ran into this interesting issue today. The count on the table showed only about 118Million rows, but the CARD in syscat.tables showed to have about 1.04 Billion rows. db2 “select count(1) from Schema.tableName” 1 ———– 118697936 1 record(s) selected. db2 “select card from syscat.tables where tabname like ‘tableName’” CARD ——————– 1048386270 1 record(s) selected. RUNSTATS […]

  • Strange: Group privileges are ignored for CREATE VIEW

    December 16, 2006

    SQL0551N <user_name> does not have the privilege to perform operation “SELECT” on object <table_name> <table_name> If a user receives this error while creating views, make sure the user is granted SELECT privilege individually. Group privileges are not considered for any table or view specified in the CREATE VIEW statement. No, its not a bug. Its […]

  • Maddocks Systems Success Story – DB2 Express Video

    December 9, 2006
  • Cross-node recovery – TSM

    November 3, 2005

    To recover/access the backup image of the database that was backed up from a different server. Typically to access production database from dev/qa Comment out “PASSWORDACCESS = generate” in file “/usr/tivoli/tsm/client/ba/bin/dsm.sys” by adding a ‘*’ in the beginning of the line. Now we should be able to query any backup image, provided you have the […]

  • Fly back in time and recover backups! :-)

    October 28, 2005
  • Parallel export for partitioned tables

    October 25, 2005

    db2_all “<<+$nodenum<db2 connect to $dbname; db2 export to $filename of del select * from $tablename where nodenumber($partitioningkey)=$nodenumber” Example: db2_all “<<+11<db2 connect to testdb; db2 export to /backup/test_table.del.11 of del select * from test_table where nodenumber(ID) = 11; db2 terminate” NOTE: Useful for large tables. Be sure to export all the partitions in which the table […]

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org