# 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'

**URL:** <https://forums.toadworld.com/t/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/32369>\
**Category:** Toad for IBM DB2\
**Created:** [January 21, 2015, 7:22am UTC](https://forums.toadworld.com/t/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/32369 "2015-01-21T07:22:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![spenico](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@spenico](https://forums.toadworld.com/u/spenico)\
**Post date:** [January 21, 2015, 7:22am UTC](https://forums.toadworld.com/t/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/32369/1 "2015-01-21T07:22:53Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![Zdenek.Sohnel](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/zdenek.sohnel/32/198_2.png) [@Zdenek.Sohnel](https://forums.toadworld.com/u/Zdenek.Sohnel)\
**Post date:** [January 21, 2015, 12:28pm UTC](https://forums.toadworld.com/t/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/32369/2 "2015-01-21T12:28:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![spenico](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@spenico](https://forums.toadworld.com/u/spenico)\
**Post date:** [January 26, 2015, 8:46am UTC](https://forums.toadworld.com/t/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/32369/3 "2015-01-26T08:46:21Z")

</div>

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

Thanks.