We have found a problem with access to an object in a library even if one
object in that library has the wrong or incompatible CCSID.
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 Kern, Mary T
Sent: Friday, July 27, 2007 3:49 PM
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/rzairfixem
ail.htm
Anyone seen anything like this in InfoCenter?
Rob Berendt
midrange.com
