Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Error during spooling

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Error during spooling
# 1  
Old 08-31-2013
Error during spooling
Hi,

I am extracting the records of a table from oracle into a csv file using spool command in unix script. I retrieve the error message as

msgcnt 18512 vxfs: mesg 001: vx_nospace - /dev/vg02/lvol12 file system full (1 block extent)

How to resolve it ?
# 2  
Old 08-31-2013
The disk is full.

Code:
df -h

will show you which disk has the problem. You have to delete files from the disk before your code will run.
# 3  
Old 08-31-2013
In case it's HP-UX:
Code:
df /dev/vg02/lvol12
df -k /dev/vg02/lvol12
bdf /dev/vg02/lvol12

# 4  
Old 09-10-2013
Thank you
# 5  
Old 09-10-2013
And you can always look at:
Code:
vgdisplay vg02

and look for the line :
Code:
Free PE                      XXXX

To see if you have some space left to extend you lvol...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Script not spooling in the designated file.

Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email. Here's what I already have. #!/bin/ksh ###################################################################### # File Name : counts.sh # Created : 2019/27/19... (1 Reply)
Discussion started by: clef
1 Replies

2. Shell Programming and Scripting

Script not spooling in result file

Hi everyone and nice to meet you :) I'm having some issues with a script I'm writing. It's probably most chaotic, I'm no ksh guru, but the idea is to extract an ID with that query, spool it into a file, and read that file making the ID a variable. This has to be done for every row extracted by... (10 Replies)
Discussion started by: Arkadia
10 Replies

3. Shell Programming and Scripting

Spooling file to excel

Hi , Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this.. O/p is coming as header till batch id ,im not able to see date_stored,type,type1.. Please any one can give me some suggestion ... (1 Reply)
Discussion started by: jkumsi
1 Replies

4. UNIX for Dummies Questions & Answers

Creating a Tar file while files are spooling

Hi I have done a search for this but couldn't find much on it. I am creating a tar file with the command below tar cvf /export/home/user/backup/*Will this is being created I have a job spooling to 5 texts files in the following directory /export/home/user/backup/STATS/ The tar files... (1 Reply)
Discussion started by: sgarvan
1 Replies

5. Red Hat

Print Spooling using raw port 9100

Hello all, I need to setup a print server that listens on three separate network interfaces, and sends jobs to the corresponding print queue. Example: 192.168.69.100 - printer1 -> Out to 139.177.69.100:9100 192.168.69.101 - printer2 -> Out to 139.177.69.101:9100 192.168.69.102 - printer2 ->... (3 Replies)
Discussion started by: ZekesGarage
3 Replies

6. UNIX for Dummies Questions & Answers

Shell scripting+connect to oracle database+spooling

Hi! Everyone I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv file then email to customer. Can anybody let me know how to go about that. I have create... (14 Replies)
Discussion started by: Mr Mo
14 Replies

7. Shell Programming and Scripting

spooling through shell script

Hi, I want to spool the output from a .sql file to a .txt file through shell script. the contents of .sql are: spool /arboru02/scripts/customer_profile_def.txt select profile_id ||','|| account_no from customer_profile_def; spool off exit and shell scrip is like: #!/bin/sh... (9 Replies)
Discussion started by: ss_ss
9 Replies

8. Shell Programming and Scripting

spooling

hi, can anyone help me with spool command.. i want to spool a file.. i am getting the output of an sql query into a file in the unix environment.. i want to spool the contents of this file to create a .lst file.. as of now, i am giving it like - sql.sql : spool on select... (4 Replies)
Discussion started by: kripssmart
4 Replies

9. UNIX for Dummies Questions & Answers

Spooling a log file with timestamp

Hi From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp. can someone help me to do that . Thanks... (2 Replies)
Discussion started by: ukadmin
2 Replies

10. UNIX for Advanced & Expert Users

HP-UX lp spooling places

Does anybody know if HP-UX uses any other directories besides /var/spool/lp/request to spool print jobs? I checked the man pages, and it only mentions /var/spool/lp in general. I was just wondering if anyone knew of some other place it might possibly use. thanks in advance for any help! (2 Replies)
Discussion started by: doeboy
2 Replies
Login or Register to Ask a Question