RE: V5R4 and ODBC -- MIDRANGE-L

Awwww. Ain't love grand?

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kern, Mary T
Sent: Saturday, July 28, 2007 10:32 AM
To: Midrange Systems Technical Discussion
Cc: Deb Klug
Subject: RE: V5R4 and ODBC

Finally (with the help of my brilliant husband GKERN-also a member on this
forum) we figured out what was wrong. It seems that V5R4 must have changed
the authority to QSYSPRT for QUSER to *EXCLUDE. Once I gave QUSER *USE
authority and bounced the server jobs the email application seems to work.
I did however have to use a new DSN created under iSeries Access V5R4. Not
sure if that's related .. But hey, I am a happy camper.

Thanks for all the responses.
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: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Evan Harris
Sent: Friday, July 27, 2007 6:50 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: V5R4 and ODBC

Sounds like a RCLSTG *DBXREF is needed to me. I've seen the system catalogs
get damaged on occasion when doing a system upgrade.

There are some neat new commands on V5R4 around the reclaim operations,
although the names escape me right now (RCLDBSTG, RCLDLOSTG.. or something
like that I think). Doing a RCL* ought to find them for you and they are
definitely in the help text for RCLSTG. You can now run a reclaim operation
with a *CHECK option to see if you need to run the actual option. Kinda
handy.

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Kern, Mary T
Sent: Saturday, 28 July 2007 7:49 a.m.
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

Interesting. I can't download THAT file with file transfer. But I can
download others. It appears to be anything in the library ... BTW,
Public has *USE on the library. I have *ALL.

Since it's file transfer I don't know what joblog to look at ...

Here's the message from file transfer:

CWBDB0040 - Catalog information server returned error SQL0913 - Row or
object QZDAPKG in QGPL type *SQLPKG in use. Cause . . . . . : The
requested object QZDAPKG in QGPL type *SQLPKG is either in use by
another application process or a row in the object is in use by either
another application process or another cursor in this application
process.

Recovery . . . : Look at the previously listed messages in the job
log (DSPJOBLOG command) or from interactive SQL press F10 (Display
messages in job log) on this display to determine if this is an object
or record lock wait time out.

Do one of the following: -- If the object is locked by another
application process, try the SQL statement again when the object is not
in use. Use the Work with Object Locks (WRKOBJLCK) command to determine
who is currently using the object. -- If the object is a schema and an
attempt was made to create a table, view, or index into this schema
under commitment control, a save-while-active operation may be in
progress on the same schema by another job in the system. Try the
request again when the save-while-active processing is complete. -- If
a record is locked by another application process, try the SQL
statement again when the record is not in use. The Display Record
Locks (DSPRCDLCK) command will determine who is currently using the
record. -- If this is a record lock held by another cursor in the same
application process, you must issue a COMMIT, ROLLBACK, or another
FETCH statement on the cursor that is holding the lock before issuing
this SQL statement. If this error occurs frequently, use the Change
Physical File (CHGPF), Change Logical File (CHGLF), or Override Data
Base File (OVRDBF) command to change the object or record wait time
out.

Here are the locks on the SQLPKG:

Object . . . . : QZDAPKG Type . . . . . : *SQLPKG
Library . . : QGPL ASP device . . : *SYSBAS

Opt Job User Lock Status Scope
Thread
QZDAINIT QUSER *SHRRD HELD *JOB
QZDASOINIT QUSER *SHRRD HELD *JOB
*SHRRD HELD *JOB
*SHRRD HELD *JOB
QZDASOINIT QUSER *SHRRD HELD *JOB
QZDASOINIT QUSER *SHRRD HELD *JOB
QZDASSINIT QUSER *SHRRD HELD *J
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: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Gary Monnier
Sent: Friday, July 27, 2007 3:26 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

Mary,

Can you access the table in question through any other PC client
application (Client Access file transfer, Excel, Crystal Reports,
etc.)? If you can have you rebooted the PC?

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

QZADSOINIT is running. We have been at CCSID 37 for several years. And
I IPL'd this morning. All Client Access Host severs are running and
set to start when TCP starts. Any more ideas?

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: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Ketzes, Larry
Sent: Friday, July 27, 2007 3:07 PM
To: Midrange Systems Technical Discussion
Subject: RE: V5R4 and ODBC

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/rzair
fixem
ail.htm
Anyone seen anything like this in InfoCenter?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

"Mary Kern" <mtkern@xxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/26/2007 08:02 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

To
"Midrange-L" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
V5R4 and ODBC

I have a PC (web based) application that uses ODBC to connect to a
table
on
our iSeries and then send emails using the data in that table. I used
it Friday during the day. I installed V5R4 on Friday night. Saturday
I
could
not connect to the table. I've upgraded the ODBC driver on the server
to V5R4 (at least I installed iSeries Access V5R4 that included the
ODBC
driver
and I assume it upgraded the ODBC driver). I built a new system DSN
after the V5R4 install. Still cannot connect.

Does anyone know what I might have to do to allow this application to
use the tables in this library?

Thanks!

Mary

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.19/918 - Release Date:
7/25/2007 2:55 PM

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.