If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 SQL1652N problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-17-03, 03:35
raj_sudhan raj_sudhan is offline
Registered User
 
Join Date: Sep 2003
Location: Nevada
Posts: 14
DB2 SQL1652N problem

hi,

I have installed db2 runclient on a pc that connects to a db2 server on another pc.

when i login to the pc which has client on it with a username that has administrative rights on that pc ..i can use db2 command window and db2 command processor fine.

but if i login with the username that doesn't have administrative rights, and when i try to access db2 command window ..it gives me a message

DB21652N error : external File I/O error occured.

can anyone let me know why i am getting this error and what might be the solution for this?

the database i am using is windows version of DB2 7.2

thank you
Raj
Reply With Quote
  #2 (permalink)  
Old 10-17-03, 04:13
raj_sudhan raj_sudhan is offline
Registered User
 
Join Date: Sep 2003
Location: Nevada
Posts: 14
Re: DB2 SQL1652N problem

the error looks like this:

DB2CMD.EXE->0
SQL1652N FILE I/O ERROR OCCURED.


thanks,
Raj




Quote:
Originally posted by raj_sudhan
hi,

I have installed db2 runclient on a pc that connects to a db2 server on another pc.

when i login to the pc which has client on it with a username that has administrative rights on that pc ..i can use db2 command window and db2 command processor fine.

but if i login with the username that doesn't have administrative rights, and when i try to access db2 command window ..it gives me a message

DB21652N error : external File I/O error occured.

can anyone let me know why i am getting this error and what might be the solution for this?

the database i am using is windows version of DB2 7.2

thank you
Raj
Reply With Quote
  #3 (permalink)  
Old 10-17-03, 04:29
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Do you have the Messages and Codes manuals? The manuals are downloadable from the IBM website and can be searched with Adobe Acrobat Reader.

SQL1652N File I/O error occurred.

Explanation: Error occurred either opening,
reading, writing, or closing a file.

User Response: Check the db2diag.log for
details. Also, check for disk full conditions, file
permissions, and operating system errors.
Reply With Quote
  #4 (permalink)  
Old 10-19-03, 13:22
raj_sudhan raj_sudhan is offline
Registered User
 
Join Date: Sep 2003
Location: Nevada
Posts: 14
re:SQL1652N Problem

Thank you marcus,

The problem was with the permissions to the SQLLIB folder. As soon as i gave the write permission to every user for the folder SQLLIB , everything went fine...

Raj
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On