how to set AUTOCOMMIT option in AIX


 
Thread Tools Search this Thread
Operating Systems AIX how to set AUTOCOMMIT option in AIX
# 1  
Old 05-26-2009
how to set AUTOCOMMIT option in AIX

Hi,

Can anybody tell,how to set the auto commit option in AIX,i have tried with environmental variables option like 'export db2option=-c +a'.
But its not working in my environment.

is there any other option?
# 2  
Old 05-27-2009
It's some time I worked with DB2 and have none available anymore to give you prooved information, but shouldn't it work if you use in the shell of your db2 admin/instance user
Code:
db2set DB2OPTIONS=-c

?
It should change this in DB2's registry so it is permanent and not only for this session.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Prune Option for Find Command on AIX

I need to delete all files from the working directory and its sub directories using the find command, for that I am using -prune option but some how I am having a syntax issue. I have tried the below, please help me correct the syntax find . -name \* -type f -exec rm -f {} \; >> Works but... (4 Replies)
Discussion started by: rosebud123
4 Replies

2. AIX

Will it affect my AIX LPAR security, when i set up email alerts on AIX server.

Hello, I've set up email alerts on AIX Servers. so that i can get email notifications (via mail relay server) when ever there is abnormal behavior. for example 1) my script monitors CPU/disk/memory etc... when it reaches high water ark, it will send an email alert. 2) disk usage alerts 3)... (5 Replies)
Discussion started by: System Admin 77
5 Replies

3. UNIX for Dummies Questions & Answers

Command line / script option to filter a data set by values of one column

Hi all! I have a data set in this tab separated format : Label, Value1, Value2 An instance is "data.txt" : 0 1 1 -1 2 3 0 2 2 I would like to parse this data set and generate two files, one that has only data with the label 0 and the other with label -1, so my outputs should be, for... (1 Reply)
Discussion started by: gnat01
1 Replies

4. Solaris

Set i/o option

How do we set i/o option to direct or buffered i/o using mkfs command? I mean what is the option that is to be used.. Like that block size can be mentioned by using -o bsize=<> Thanks in advance. (2 Replies)
Discussion started by: aksijain
2 Replies

5. UNIX and Linux Applications

command to check value of autocommit and isolation level

Hi, Pls let me know command to get following: 1. how to check current value of autocommit 2. how to check current value of isolation level I am using mysql-5.0.26 on unix -Thanks (2 Replies)
Discussion started by: newbielgn
2 Replies

6. Web Development

[Solved] Disable mySQL autocommit

Hi. Does anyone know how I can disable auto-commit in mySQL? I've been Googling it for ages, and one suggestion that always comes up is adding this to /etc/my.cnf: ... init_connect='SET autocommit=0' But that didn't work. I then read that this wouldn't work anyway for a... (4 Replies)
Discussion started by: Scott
4 Replies

7. UNIX for Dummies Questions & Answers

AIX find command using prune option

Hi, I am trying to find some files in a directory and then remove/list them if they are 30 days old. I also have 2 directories in that directory which I need to skip. Can someone please tell me what is the correct syntax? find /developer/. -name "lost+found" "projects" -prune -o -type f... (2 Replies)
Discussion started by: tkhan9
2 Replies

8. Shell Programming and Scripting

lynx browser set permanently option

hi all, is there somebody that know how can I set an permanently option for the lynx text browser? The reason is if I open some URL's and type my login infos then lynx show follow message: P)roceed, use G)ET or C)ancel Server asked for 301 redirection of POST content to URL: The UNIX... (1 Reply)
Discussion started by: research3
1 Replies

9. AIX

AIX 5L 64bits v5.3 Java option (Xjit)

Hi, I would like to know, we are using Oracle Application (E Business Suite) on AIX 5L 64bits v5.3. We have to add the -Xjit:count=0 to the java parameter for Oracle. I read the IBM AIX Guide but I can't figure out where or how to add that parameter. Anyone know how to do it? ... (0 Replies)
Discussion started by: Nayas
0 Replies

10. Solaris

where can i set editor option to yes

Hi all I am new to this forum (just registered) I need help from you guys Even if it is a basic question please don't hesitate to answer.Any answer will be helpful to me I am unable to get the previously entered commands by pressing uparrow When i enered uparrow it is giving ^[[A I got... (2 Replies)
Discussion started by: oracle_sri
2 Replies
Login or Register to Ask a Question