Toad DB2 Freeware 6.0.0.373 LUW Error while viewing metadata in SYSCAT [DB2 9.7.4.4] -- Could not load type 'IBM.Data.DB2Types.DB2SmartLOB'

Steps:

  • SYSCAT selected as current schema in Object Explorer. (The Object Explorer schema list is filtered.)
  • Flat tree Object Explorer view selected
  • Selecting individual SYSCAT metadata views
  • Looking at the Data tab
  • Jumping from SYSCAT view to SYSCAT view (always with the Data tab selected) to view the actual rows in the views (not the column definitions)
  • Had looked at all INDEX… views
  • Blew up when I selected the SYSCAT.FUNCTIONS view
    System.TypeLoadException
    Could not load type ‘IBM.Data.DB2Types.DB2SmartLOB’ from assembly ‘IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208’.
    Stack Trace:
    at Quest.Toad.DB2.DB2ToadConnectionUtils.RepositoryEditors.repositoryItemBlobEdit_QueryDisplayText(Object sender, QueryDisplayTextEventArgs e)
    at DevExpress.XtraEditors.Repository.RepositoryItemPopupContainerEdit.RaiseQueryDisplayText(QueryDisplayTextEventArgs e)
    at DevExpress.XtraEditors.Repository.RepositoryItemPopupContainerEdit.GetDisplayText(FormatInfo format, Object editValue)
    at DevExpress.XtraEditors.ViewInfo.BaseEditViewInfo.GetDisplayText()
    at DevExpress.XtraEditors.ViewInfo.TextEditViewInfo.GetDisplayText()
    at DevExpress.XtraEditors.ViewInfo.BaseEditViewInfo.OnEditValueChanged()
    at DevExpress.XtraEditors.ViewInfo.BaseEditViewInfo.set_EditValue(Object value)
    at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellEditViewInfo(GridCellInfo cell, Point mousePos, Boolean canFastRecalculate, Boolean calc)
    at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.CreateCellEditViewInfo(GridCellInfo cell, Boolean calc, Boolean allowCache)
    at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.RequestCellEditViewInfo(GridCellInfo cell)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRowCell(GridViewDrawArgs e, GridCellInfo ci)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRegularRow(GridViewDrawArgs e, GridDataRowInfo ri)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRow(GridViewDrawArgs e, GridRowInfo ri)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawRows(GridViewDrawArgs e)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawContents(GridViewDrawArgs e)
    at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.Draw(ViewDrawArgs ee)
    at DevExpress.XtraGrid.Views.Base.BaseView.Draw(GraphicsCache e)
    at DevExpress.XtraGrid.GridControl.OnPaint(PaintEventArgs e)
    at DevExpress.Utils.Drawing.ControlPaintHelper.PaintWithErrorHandling(PaintEventArgs paintEventArgs, Int32 layer)
    at DevExpress.Utils.Drawing.ControlPaintHelper.ProcessWMPaint(Message& m)
    at DevExpress.XtraGrid.GridControl.CheckProcessMsg(Message& m)
    at DevExpress.XtraGrid.GridControl.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Hi,

Can you please take a look at the version of your Default IBM DB2 Client? Based on stack trace it seems you have 9.7.4.4, but let us know if that is correct.

Then based on Release notes for Toad for IBM DB2 6.0 works with a DB2 Client 9.7.6 to 10.5.x.

Zdenek

You’re right. I’m using 9.7.4.4. I’ll upgrade and see if that makes a difference.

Thanks.