Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Upgrade or remove obsolete datablade

  • 1.  Upgrade or remove obsolete datablade

    Posted Fri August 28, 2020 08:38 AM
    Edited by TOM GIRSCH Fri August 28, 2020 08:38 AM

    Somehow, several of my databases got munged somewhere along the line, such that spatial.8.21.FC5 is registered there. The current version (for 12.10.FC14) is 8.22.FC2. However, in blademgr, I'm unable to unregister 8.21.FC5:

    ids__chaos_dev__b1>unregister spatial.8.21.FC5 euroreserve Unregister module spatial.8.21.FC5 out of database euroreserve? [Y/n]Y blademgr: ERROR: DataBlade spatial.8.21.FC5 could not be unregistered from database euroreserve. Use 'show last log' for details of failures in module's scripts. ids__chaos_dev__b1>ids__chaos_dev__b1>show last log Mack Informix-Manager DataBlade Module Version 5.00 - Aug 14 2020 Nothing to report.


    In online.log, I see:

    08/28/20 12:04:52 INFO (autoreg 340455) SYSBldUnregister - Could not find any objects registered for DataBlade module "spatial.8.21.FC5" - unknown error - check online log and sysblderrorlog table for more information


    Has anyone else encountered this and/or have any idea how to fix it?

    In most cases, the spatial blade is unused and can simply be removed. However, in one case, it is used, so I need to get blademgr to reflect the actual version in use, 8.22.FC2

    [Yes, I've opened a case on this, but thought someone here might have already encountered this and know how to deal with it.]

    ------------------------------
    TOM GIRSCH
    ------------------------------


  • 2.  RE: Upgrade or remove obsolete datablade

    Posted 30 days ago

    Hi Tom,

     

    I've had problems with the BladeManager utility (windows) in the past removing a datablade.

    The SYSBldPrepare() to unregister may help you, it let me fix my problem at the time of removing the timeseries datablade.

    This is docs for v12.10:  https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_2051.htm

     

    Regards, Bryce.

     






  • 3.  RE: Upgrade or remove obsolete datablade

    Posted 30 days ago

    No love:

    $ dbaccess -a -e reserve << EOF^JEXECUTE FUNCTION sysbldprepare('spatial.*','drop');^JEOF Database selected. EXECUTE FUNCTION sysbldprepare('spatial.*','drop'); (expression) 0 1 row(s) retrieved. Database closed. $ blademgr ids__chaos_dev__b1>list reserve DataBlade modules registered in database reserve: ifxrltree.2.00 spatial.8.21.FC5

    ------------------------------
    TOM GIRSCH
    ------------------------------