Batch command problem

[Andrew Beal]

Hi,

I have a script that perfoms a reorg on our databases. The script works fine when it is executed through cron, or from the command line, but when I try to use the batch command to execute the script it starts ok, but when the reorg is creating a structured copy of the database it stops whenever the data base reaches 2147483136 bytes... Like i said it works using all the other methods, just not when I try to test it using the batch command... does anyone have any idea what could be going on?

I had a look at the Kernel paramaters, and there is one called shmmax which is set at a number almost exactly the same as that number... and apparently that specifies the max available shared memory... though I am not sure it would be that causing the problem as the script works using cron, or the command line etc...

Hp-ux 11.00

Regards,

Andrew

[Steven E. Protter]

The filesystem the reorg is trying to is not setup for largefiles.

What you need to do is use fsadm to convert the fs to largefiles.

You may need to dismount the filesystem first.

umount /fsname

fsadm -F vxfs -o largefiles /dev/vg01/rfsname

Then you need to edit /etc/fstab and change the mount instructions for the filesystem from nolargefiles to largefiles

It would be even better to back up the filesystem, umount it and use newfs -F vxfs -o /dev/vg01/rfsname

Either way after conversion


mount /fsname

If you did newfs restore the data.

This error is coming up becaue a file is trying to get bigger than 2 Gig and the filesystem can not handle it.

SEP

Note that for 11.11 there is no largefiles entry in /etc/fstab, its not needed or supported.

[Steven E. Protter]

shmmax will ignore any setting more than 25% of total memory.

total memory is defined as physical memory plus swap

If you have 2Gig of memory and 4 Gig of swap, shmmax won't observe settings any higher than 1.5 Gig.

Here is a performance document that might help with these issues though I don't believe that to be your issue.

Performance Doc
http://www1.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&mode=id&admit=-682735245+1053636168960+28353475&searchCrit=allwords&printable=true

[Andrew Beal]

Thanks for you quick reply's.

Here is the contents of my /etc/fstab file, and it appears the volume is actually setup to allow large files, I have also checked this through SAM. The volume I am reorging to is /p01.

/dev/vg00/lvol3 / vxfs delaylog 0 1
/dev/vg00/lvol1 /stand hfs defaults 0 1
/dev/vg00/lvol4 /tmp vxfs delaylog 0 2
/dev/vg01/lvol9 /home vxfs delaylog 0 2
/dev/vg00/lvol6 /opt vxfs delaylog 0 2
/dev/vg00/lvol7 /usr vxfs delaylog 0 2
/dev/vg00/lvol8 /var vxfs delaylog 0 2
/dev/vg01/lvol2 /u01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg03/lvol1 /u03 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg04/lvol1 /u04 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg00/lvol10 ... swap pri=2 0 0
/dev/vg01/lvol1 /wkforce vxfs log,nodatainlog,largefiles,rw,suid 0 2
/dev/vg03/lvol2 /p01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg02/lvol1 /u02 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg04/lvol3 /a01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg02/lvol4 /b01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg05/lvol5 /c04 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg05/lvol4 /c03 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg05/lvol3 /c02 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg05/lvol2 /c01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg05/lvol1 /prod vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg02/lvol3 /c05 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg01/lvol6 /c06 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg03/lvol3 /c07 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg01/lvol3 /opt/sw/class vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg01/lvol4 /opt/sw/cl4odbc vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg00/lvol11 ... swap pri=3 0 0
/dev/vg01/lvol7 /MT000 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg02/lvol2 /opt/sw/sup2000_nz vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg01/lvol5 /nz01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg00/lvol12 /opt/sw/cl4open_test vxfs log,nodatainlog,largefiles,rw,suid 0 2
/dev/vg01/lvol8 /opt/sw/sup2000 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg03/lvol4 /src vxfs log,nodatainlog,largefiles,rw,suid 0 2
/dev/vg02/lvol5 /reorg vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg01/lvol10 /opt/sw/sup2000_hk vxfs rw,suid,largefiles,delaylog,datainlog 0 2
/dev/vg03/lvol5 /hk01 vxfs rw,suid,largefiles,delaylog,datainlog 0 2

Cheers ;)

Andrew