'DPF' Tag

  • 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 […]

  • 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 […]

  • 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