ontape to disk problem

Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ

The value of LTAPEDEV is ONLY read from the ONCONFIG file at engine startup. After that ontape reads the value from shared memory. So changing the value in the ONCONFIG file with an editor will have no effect until you bounce the engine. HOWEVER, if you use onmonitor to change the value onmonitor will also change the contents of shared memory. Art S. Kagel ----- Original Message ----- From: Cj Butcher <ids@iiug.org> At: 7/18 16:51:24 Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

What is your TAPESIZE set to in your ONCONFIG? Also, this is bound by the amount that can be written ( using write() ) on a single open(). Since ontape uses open() and write(), this will limit the tape size to whatever your platform is bound by, I am not sure what linux limitations are. For starters, check your TAPESIZE setting (this should be Kb) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CJ BUTCHER Sent: Wednesday, July 18, 2007 3:51 PM To: ids@iiug.org Subject: ontape to disk problem [9584] Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Whether you manually edit your onconfig file or use onmonitor to change this parameter "TAPEDEV" to /mnt2/PRD01.bak, your ontape should respond to as: Please mount tape 1 on /mnt2/PRD01.bak and press Return to continue ... but if it responds as: Please mount tape 1 on /mnt2 and press Return to continue ... then perhaps, you may have a buggy version 9.4? ----- Original Message ---- From: CJ BUTCHER <creighton_butcher@adaptec.com> To: ids@iiug.org Sent: Wednesday, July 18, 2007 4:50:54 PM Subject: ontape to disk problem [9584] Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting

Thanks for all the responses...here is where I am: Here part of my onconfig: TAPEDEV /mnt2/PRD01.bak #TAPEDEV /dev/st1 # Tape device path #TAPEDEV /dev/null # Tape device path TAPEBLK 256 # Tape block size (Kbytes) TAPESIZE 700000000 # Maximum amount of data to put on tape (Kbytes) I tried running the onmonitor program and following error: onmonitor 4GL run-time error number -7206. LANG or LC_CTYPE environment variable is invalid. When I checked my local setting: LC_CTYPE=en_US I did notice some other places that show it being equal to en_US.UTC-8 Thoughts?? CJ

Hi, Check the permissions on the /mnt2/PRD01.bak files, ontape seems to like a 777 permissions regime. I have had a similar issue and this corrected it. Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com **** _/ _/ _/ _/ **** Desk: +61 8 8408 4273 **** _/ _/ _/_/_/ **** Mobile: +61 417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Joe Plugge Sent: Thursday, 19 July 2007 6:50 AM To: ids@iiug.org Subject: RE: ontape to disk problem [9586] What is your TAPESIZE set to in your ONCONFIG? Also, this is bound by the amount that can be written ( using write() ) on a single open(). Since ontape uses open() and write(), this will limit the tape size to whatever your platform is bound by, I am not sure what linux limitations are. For starters, check your TAPESIZE setting (this should be Kb) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CJ BUTCHER Sent: Wednesday, July 18, 2007 3:51 PM To: ids@iiug.org Subject: ontape to disk problem [9584] Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Create a soft link to point to the file (660 for permissions and informix:informix for ownership) and have TAPEDEV refer to that link. I've done this with 800GB databases in the past. Make the TAPESIZE larger than your database and adjust the TAPEBLK for you OS. I left TAPEBLK at 512 vs. 4096 on my AIX system...performance was better for some reason. You will get prompted for the initial mount, but that should be it. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Wednesday, July 18, 2007 5:26 PM To: ids@iiug.org Subject: Re: ontape to disk problem [9587] Whether you manually edit your onconfig file or use onmonitor to change this parameter "TAPEDEV" to /mnt2/PRD01.bak, your ontape should respond to as: Please mount tape 1 on /mnt2/PRD01.bak and press Return to continue ... but if it responds as: Please mount tape 1 on /mnt2 and press Return to continue ... then perhaps, you may have a buggy version 9.4? ----- Original Message ---- From: CJ BUTCHER <creighton_butcher@adaptec.com> To: ids@iiug.org Sent: Wednesday, July 18, 2007 4:50:54 PM Subject: ontape to disk problem [9584] Hi, I'm trying to run ontape to backup my database to disk. The db is 500GB. version 9.4 running on linux. I have mounted drive with plenty of space. I've updated my onconfig file to point to my disk and keep getting the message: Please mount tape 1 on /mnt2 and press Return to continue ... my onconfig is: TAPEDEV /mnt2/PRD01.bak LTAPEDEV /daylogs/ONTAPE_PRD_LOGS/prd_ontape_logs.bak What am I missing??? Thanks, CJ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc. UBS Financial Services Incorporated of Puerto Rico

Thanks...same error. :-<

That did it! I added a 0 to my TAPESIZE and now it works. Value was: 700000000 now it's @: 7000000000 and working. Thank you. CJ