Running the EXPORT on AIX DB2 V8.1.3

Richard Hagedorn

Running the EXPORT on AIX DB2 V8.1.3
I am getting the following error on my export. Can someone give me the link
to the error codes manual?



SQL3104N The Export utility is beginning to export data to file

"/EXPORT/ex_cookie_cache_tbl.ixf".



SQL3001C An I/O error (reason = "sqloopen -2079391743") occurred while

opening the output file.



SQL3105N The Export utility has finished exporting "0" rows.



Thanks for the help!


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dan Michaelis

Re: Running the EXPORT on AIX DB2 V8.1.3
(in response to Richard Hagedorn)
Richard,



I can't help with the error code manual link, but on AIX, you can do:



db2 ? SQL3104N

db2 ? SQL3001C

db2 ? SQL3105N



And get the equivalent of what is in the error code manual. Unfortunately,
it's not going to be very helpful... here's what I got (on Solaris, but
it'll likely be the same as what you get)



---> db2 ? SQL3001C





SQL3001C An I/O error (reason = "<reason>") occurred while

opening the output file.



Explanation:



A system I/O error occurred while opening the output file.



The command cannot be processed. No data is processed.



User Response:



For IMPORT/LOAD, verify that the output file exists. For EXPORT,

verify that the output media has enough free space. Resubmit the

command with a valid output file name, including the correct

path. Look in the message file for additional information.





Wish I could be the bearer of better tidings; I assume you've already looked
at the message file, and the information is inconclusive? If you've written
nothing at all, I'd suggest looking at file permissions; that always seems
to be the thing that bites me on stuff like this.



Let me know if that helped.



Thanks.





Dan Michaelis



Database Administrator/Developer

eOriginal

351 West Camden Street

Suite 800

Baltimore, MD 21201



410.625.5187 (phone)

410.659.9799 (fax)

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Pierre Evans

Re: Running the EXPORT on AIX DB2 V8.1.3
(in response to Richard Hagedorn)
Richard,
usually that kind of error come about because the utility cannot write to the file/path you have specified.So I'd recommend checking :

1 - Does the path exist ?
2 - Does the id doing the export have write permissions to the directory where you are trying to
export ?
3 - Is the file system full ?
4 - Is it a NFS mounted directory? Check if the mount has been disabled for some reason.

Hope that helps
Pierre





---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Richard Hagedorn

Re: Running the EXPORT on AIX DB2 V8.1.3
(in response to Pierre Evans)
It does appear to be write permissions, thanks for the help!



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of P. Evans
Sent: Thursday, January 13, 2005 7:34 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Running the EXPORT on AIX DB2 V8.1.3



Richard,

usually that kind of error come about because the utility cannot write to
the file/path you have specified.So I'd recommend checking :



1 - Does the path exist ?

2 - Does the id doing the export have write permissions to the directory
where you are trying to

export ?

3 - Is the file system full ?

4 - Is it a NFS mounted directory? Check if the mount has been disabled for
some reason.



Hope that helps

Pierre



_____

Do you Yahoo!?
Yahoo!
<http://us.rd.yahoo.com/mail_us/taglines/security/*http:/promotions.yahoo.co
m/new_mail/static/protection.html> Mail - You care about security. So do
we.
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm