Error retrieving data from DB2 system

• Leo Sagum-442254

  Grasshopper

  Points: 23

  More actions

  February 3, 2008 at 5:22 pm

  #69557

  Hello Guys,

  Appreciate if you could check on this error. I'm retrieving data from a DB2 system and i got this error "Could not fetch a row from OLE DB provider 'DB2OLEDB' ". I can query the first 8101 records but stops at the next record. What makes it surprising is that i can query the record if a filter is provided.

  Thanks in advance,

  Leo

• dbaker-620086

  SSCrazy

  Points: 2336

  More actions

  February 8, 2008 at 10:28 am

  #776519

  guesses

  1. data in that row has incompatible datatype [so you need some cast/convert function]

  2. index and/or keyset cursor is flawed [metadata needs refreshing]

  3. somebody DB2-side trashed the row [transient, depending on isolation level]

  I'd be tempted to use DB2 tools to list that next row in detail

  - could also try binary-chop on columns to focus on which the dodgy column(s)

  select c1,c3,c5 from DB2.db.sch.obj where PK=8102

  also check that your OLEDB drivers (and MDAC?) are latest patch-level etc