Q
Problem solve Get help with specific problems with your technologies, process and projects.

Slow ODBC connection

I run Windows NT 4.0 on my PC. I use Access ODBC driver for my database. Suddenly the connectivity of my database has become very slow. Can you tell me why this is happening?

The best way to look for clues to a slow ODBC connection is via the iSeries mechanism as follows:

* Find out the user name you are using for connection (For example user ABC).

* Go to the iSeries and issue command WRKOBJLCK ABC *USRPRF.

* Locate a job called QZDASOINIT look in the joblog for possible problems.

* You may need to update the QAQQINI file in QUSRSYS in order to force debug messages to appear in the JOBLOG.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.


Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close