Need assistance on spreading logical logs
Hans Kamann asked how to spread logical logs over two disks on IDS 11.70 so one log can be backed up while another is in use. Art Kagel advised creating two dbspaces, one per disk, and adding logs alternately with onparams -a -d, and supplied a ksh loop. Hans thanked him. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
IDS 11.70 I need advice on how to setup a spread of logical logs over at least two disks. the idea behind this is to enable one logical log to be backed up and another being used which may improve performance.
No problem Hans. Just create two dbspaces for the logical logs, one on each
disk. Then create the logs alternating first on one disk then on the other.
Easy shell script:
##########start script add_logs
#!/bin/ksh
nlogs=$1
nruns=$(( ($1 + 1) / 2 )); #Handle odd numbers
while [[ $nruns -gt 0 ]]; do
onparams -a -d first_log_dbs
onparams -a -d second_log_dbs
nruns=$(( nruns - 1 ))
done
##########end
add_logs 24
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Wed, Jul 6, 2016 at 5:12 AM, HANS KAMANN <hans.kamann@web.de> wrote:
> IDS 11.70
>
> I need advice on how to setup a spread of logical logs over at least two
> disks. the idea behind this is to enable one logical log to be backed up
> and
> another being used which may improve performance.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1143e798fae54b0536f6392e
Many thanks, I new that AK would offer a helping hand :-)
On Wednesday, July 6, 2016, HANS KAMANN <hans.kamann@web.de> wrote: > Many thanks, I new that AK would offer a helping hand :-) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c05e7ca57c9530536f68402