RE: V5R4 and ODBC -- MIDRANGE-L

Not sure if this helps anyone, but IBM told us that after making the change
of system value CCSID from 66535 to 37, we needed to take the system to a
restricted state and then back up again. We will be doing this over the
weekend.

Larry

Larry Ketzes | Senior iSeries System Administrator | AIG / ALICO - American
Life Insurance Company
One ALICO Plaza, 600 N. King Street, AMIS | Wilmington, DE 19801 | *:
302.594.2146 | 7: 302.830.4524| *: larry.ketzes@xxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: Friday, July 27, 2007 3:02 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

You need the STRHOSTSVR command, or use iSeries Navigator and open Network >
Servers > iSeries Access...

Here's a little help...
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii
/rzaiiodbc25.htm

To check quickly, just WRKJOB QZDASOINIT and see if there are any active
jobs. This is the job that services ODBC requests...

hth,
Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Kern, Mary T
Sent: Friday, July 27, 2007 12:03 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

I can see the user log in in the history log. So the profile would be fine.
Looking in CFGTCP, I don't see a TCP/IP server. Should I be looking
somewhere else?

Thanks!
Mary

¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
Mary Kern
Director of Information Services
University of Toledo Foundation
2801 W Bancroft St Mail Stop 319, Toledo, OH 43606
Voice: (419) 530-5611 (800) 640-0147 Fax: 419-530-2895
Email: Mary.kern4@xxxxxxxxxxx
"Three things in human life are important. The first is to be kind.
The second is to be kind. The third is to be kind. -- Henry James
¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«

-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Friday, July 27, 2007 11:08 AM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

Did the host servers start?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Friday, July 27, 2007 9:00 AM
To: Midrange Systems Technical Discussion
Subject: Re: V5R4 and ODBC

Mary,

You've received some good suggestions. Starting with V5R3 and beyond, IBM
got a lot more picky with CCSID and has caused a lot of issues.

Another possibility, however remote, is an expiration of the user profile
associated with that job, etc.

Be nice if IBM had a checklist for ODBC trouble shooting like they did
with email
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzair/rzairfixem
ail.htm
Anyone seen anything like this in InfoCenter?

Rob Berendt