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
