Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Problem after installing db2 9.7

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Sun Aug 21, 2011 10:08 am    Post subject: Problem after installing db2 9.7
Reply with quote

Hi,

We have a vb6 application which was working fine until we installed db2 client v9.7.

Application datagrid and after entering all the details in first row, details are inserted into the database with datagrid.beforeupdate event.

Datagrid control is bound to database.

Code:
Private Sub DataGrid1_BeforeUpdate(Cancel As Integer)

If bolMyCriticalErrorFlg Then
Cancel = True
End If

End Sub

Application is just freezing in this event after installing db2 client version 9.7. It works fine if we install 9.1 again.

Any thoughts...
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 21, 2011 11:31 am    Post subject:
Reply with quote

Is this a server or client? Beside that how do you know that your application freezes in your Before Update exit? Did you run it in a VB
debugger? Did the upgrade run without errors?
Consult the following link :

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.qb.upgrade.doc/doc/t0022632.html
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Sun Aug 21, 2011 11:53 am    Post subject:
Reply with quote

PeterHolland wrote:
Is this a server or client? Beside that how do you know that your application freezes in your Before Update exit? Did you run it in a VB
debugger? Did the upgrade run without errors?
Consult the following link :

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.qb.upgrade.doc/doc/t0022632.html


Its' a client. Yes i tried to debug the application using vb6. Upgrade was fine without any errors. Besides application is able to connect to db2, select queries are working and even insert statements are working fine.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 21, 2011 12:28 pm    Post subject:
Reply with quote

Quote:

Yes i tried to debug the application using vb6

And what happened?
Do you use the OLE DB,ODBC or IBM DB2 .Net Data Provider?
Do you have the latest Framework installed?
Are there any error messages?
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Sun Aug 21, 2011 12:31 pm    Post subject:
Reply with quote

It just freezes after that subroutine. Application uses ODBC driver.
What framework? Application is in vb6 and not dot net.
There are no error messages.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 21, 2011 12:43 pm    Post subject:
Reply with quote

Maybe the next link is applicable :

http://support.microsoft.com/kb/288346
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Sun Aug 21, 2011 12:55 pm    Post subject:
Reply with quote

PeterHolland wrote:
Maybe the next link is applicable :

http://support.microsoft.com/kb/288346


Nope, this is not the problem with my case. Beforeupdate event is getting fired. It is at this event, application is getting frozen.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 21, 2011 1:30 pm    Post subject:
Reply with quote

And if you set cancel to false if your flag is not on?
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Sun Aug 21, 2011 1:45 pm    Post subject:
Reply with quote

PeterHolland wrote:
And if you set cancel to false if your flag is not on?


It is not going inside the if condition. So value of Cancel is not getting altered. I compared the datagrid values and it is all the same when I run the application with db2 v 9.1 and DB2 v 9.7
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Aug 21, 2011 2:05 pm    Post subject:
Reply with quote

Hello,

Quote:
Besides application is able to connect to db2, select queries are working and even insert statements are working fine.
I'm confused. . . If selects and inserts are working, when does the "freeze" occur?

It may be possible that the interface to v9.7 requires a more current interface on the pc?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 21, 2011 2:07 pm    Post subject:
Reply with quote

Well i'm at a loss for now. Maybe your VB6 people can help you.
Maybe other events are triggered before your event is fired.
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Mon Aug 22, 2011 7:20 am    Post subject:
Reply with quote

Dick Sherrer,
Explicit queries are working fine, here the datagrid control is bound to the database. So when the user moves to the next row, the first row in datagrid gets inserted into the bound table. This is working fine in DB 9.1, but doesn't work with 9.7.

Beforeupdate event description:
When the user moves to another row or the Recordset object's Update method is executed, data is moved from the DataGrid control's copy buffer to the Data control's copy buffer and written to the database
[Source: MSDN]
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 22, 2011 8:39 am    Post subject:
Reply with quote

Hello,

Ok, but i repeat:
Quote:
It may be possible that the interface to v9.7 requires a more current interface on the pc?


You may need to contact DB2 Support to confirm this or to see if there are any VB6 special considerations.
Back to top
View user's profile Send private message
vinay19

New User


Joined: 31 May 2007
Posts: 24
Location: Bangalore

PostPosted: Mon Aug 22, 2011 9:48 am    Post subject:
Reply with quote

Thanks a lot. I will contact vb6 people first.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 22, 2011 10:09 am    Post subject: Reply to: Problem after installing db2 9.7
Reply with quote

You're welcome - good luck icon_smile.gif

Is there any chance to upgrade to a more current release of VB? I don't "do" vb, but my clients that write vb apps are well beyond vb6. . .

d
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 22, 2011 1:40 pm    Post subject:
Reply with quote

Vinay,

Check in the Windows Event Viewer, may be you can see some messages there.

Thanks,
Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm
No new posts TXT2PDF problem - printing @ in PDF vipul65 All Other Mainframe Topics 9 Thu Aug 25, 2016 12:48 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us