Bad Hummingbird performance (doc.mgmt.system)? Upgrade to 10.2 !

Hummingbird, the document management system, uses an Oracle database 91 on Sun at this company. Performance of several functions were very bad. 40 seconds to give me a document in some cases.  Bad sql-statements all over the place.

Installed a Linux system with 10.2.0.4 on it, made an export on SUN of the user DOCSADMIN, moved it to the Linux machine, imported it and transformed the tnsnames on the DM-server of Hummingbird. Very straightforward.  It gave Hummingbird a performance-boost. The select statement of 40 sec went down to 2 seconds. Be aware: turn on the statistics on SYS ! This will be done automatically when you create a database with DBCA by the way.

More in detail:

Preparations:
– Check the tablespaces.

– Check the memory use

Migration:
– DM server down
– Make an export
– Copy the export to the Linux machine
– Create role DOCS_USERS
– Create users docsadm en docsuser (generated by Toad… ):

CREATE USER DOCSADM
IDENTIFIED BY VALUES ‘<values on the old db>’
DEFAULT TABLESPACE DOCSVAL
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 3 Roles for DOCSADM
GRANT CONNECT TO DOCSADM;
GRANT CTXAPP TO DOCSADM;
GRANT DBA TO DOCSADM;
ALTER USER DOCSADM DEFAULT ROLE ALL;
— 1 System Privilege for DOCSADM
GRANT UNLIMITED TABLESPACE TO DOCSADM;
— 13 Object Privileges for DOCSADM
GRANT SELECT ON SYS.AUDIT_ACTIONS TO DOCSADM;
GRANT SELECT ON SYS.DBA_DIRECTORIES TO DOCSADM;
GRANT SELECT ON SYS.DBA_EXTENTS TO DOCSADM;
GRANT SELECT ON SYS.DBA_INDEXES TO DOCSADM;
GRANT SELECT ON SYS.DBA_IND_COLUMNS TO DOCSADM;
GRANT SELECT ON SYS.DBA_OBJECTS TO DOCSADM;
GRANT SELECT ON SYS.DBA_SEGMENTS TO DOCSADM;
GRANT SELECT ON SYS.DBA_TABLES TO DOCSADM;
GRANT SELECT ON SYS.DBA_TEMP_FILES TO DOCSADM;
GRANT SELECT ON SYS.DBA_USERS TO DOCSADM;
GRANT SELECT ON SYS.V_$INSTANCE TO DOCSADM;
GRANT SELECT ON SYS.V_$LATCHNAME TO DOCSADM;
GRANT SELECT ON SYS.V_$PARAMETER TO DOCSADM;

CREATE USER DOCSUSER
IDENTIFIED BY VALUES ‘<values of the old server>’
DEFAULT TABLESPACE DOCSVAL
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 2 Roles for DOCSUSER
GRANT CONNECT TO DOCSUSER;
GRANT DOCS_USERS TO DOCSUSER;
ALTER USER DOCSUSER DEFAULT ROLE ALL;
— 4 Tablespace Quotas for DOCSUSER
ALTER USER DOCSUSER QUOTA UNLIMITED ON DOCSPROF;
ALTER USER DOCSUSER QUOTA UNLIMITED ON DOCSVAL;
ALTER USER DOCSUSER QUOTA UNLIMITED ON DOCSIND;
ALTER USER DOCSUSER QUOTA UNLIMITED ON DOCSTEMP;

Import de dump-file:

– export NLS_LANG=’AMERICAN_AMERICA.WE8ISO8859P1′
imp system/<passwd> file=/backup/oradata/backup/hbt/exports/export_hbt.dmp log=/backup/oradata/backup/hbt/exports/imp_hbt.log buffer=10000 fromuser=docsadm touser=docsadm

Edit the tnsnames.ora on the DM-server.

The Hummingbird – release used, is 5.1.0.5,  service release 6, maintenance 4. You need also to copy some files on the DM-server:

To use the English Library Generator:  Copy Library Generator (tblcomp.exe), and
the files DOCSOR32.DLL and DOCSDB32.DLL to the …\Hummingbird\DM
Server\Programs folder

Restart the DM-server.

By | 2009-03-16T20:56:12+00:00 March 16th, 2009|Categories: Database|6 Comments

About the Author:

6 Comments

  1. Vincent Kolmer July 31, 2009 at 4:31 pm

    Hey Job,

    Could you give some information as to why the hummingbird application works better on 10.2.0. 4 instead of the 9 version?

    If you say “Bad sql-statements all over the place” what did the 10.2.0.4 do different tot these statements?

  2. Job August 21, 2009 at 8:43 am

    Hey Vince, long time no see…

    You are quite right, the post is not a in-depth analysis of a bad performing application. Short answer: don’t exactly know.
    The tight time-frame to investigate this and the fact that the project of upgrading was already started, did not help for an analysis. The ‘bad performing sql-statements’ I was talking about, had joins with number keys which were compared to varchar2-keys for example, and the order by-clause was performance-degrading. The path Oracle chose was not bad at all, giving the circumstances. Though I tried several things, like indexes (deleting, creating), cleaning log-table, hints, db_cache_size, parameters like optimizer_index_cost_adj etc. But I’m not Jonathan L…
    As a test, imported the bunch in 10g, ran statistics on owners and sys/system (default), and it performed smoothly. The path Oracle chose for the statements was the same at first sight by the way, didn’t compare this to the bone.
    Regards,
    Job.

  3. nicole imad March 2, 2011 at 9:51 am

    does any one know if hummingbird dm is just document managment or also file server?

  4. admin March 2, 2011 at 10:15 pm

    The one I ment in the post is just a doc.mgmt system. However the files are stored on a file-system, the are being accessed through the meta-data in the Oracle database, so it’s not a filesystem in your context. I think that you mean ‘Exceed’, a product of the company ‘Opentext’, formely known as Hummingbird. Regards.

  5. Meriem.O March 1, 2012 at 11:11 pm

    Hi, I need your help!!!
    I’m trying to install eDOCS but in the step of generating librarie i’ve got the error message: abnormal program termination ( with the header tblcomp.exe)
    Plz help me 🙂
    Best regards

  6. admin March 2, 2012 at 12:13 pm

    Hi, this not very much information to give a good estimate of the cause, but as tblcomp.exe is updating and changing tables, you can check the privileges of the connectd user and/or the connection itself. Otherwise the client-dll’s versions , or a wrong path to this libraries.

Leave A Comment