RSS Feed: IIUG Forum: Admin Tools

The admin-tools forum is for discussing the Informix database administration tools. These are primarily the Informix Server Administrator (ISA), and Server Studio from AGS.

Artur-P011321 Wygonowski est absent(e).
Posted by: artur.wygonowski@pl.michelin.com (artur.wygonowski@pl.michelin.com) - Thu, 22 Jul 2010 10:36:29 EDT
Nie b=EAdzie mnie w pracy od 2010-07-19 i nie wr=F3c=EA przed 2010-08-=
09.

W sprawie Kart Security Box - kontakt Agnieszka Jastrz=EAbska tel. 4165=
.. W
pilnych sprawach prosz=EA si=EA kontaktowac z Tomkiem Modrzy=F1skim tel=
4990.
I am on holidays till 09.08.2010. With urgent cases please contact with=

T.Modrzynski tel. +48895394990.=




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3392]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Stop logical log backup
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 22 Jul 2010 09:42:21 EDT
It's our test environment, so we really do not care about logical backup.
However, I see a warning from IBM website.

Warning:
Do not set LTAPEDEV to /dev/null or nul when you use ON–Bar to back up logical
logs.


http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.adref.doc/adref109.htm




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3391]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Stop logical log backup
Posted by: miller3@us.ibm.com (John Miller iii) - Thu, 22 Jul 2010 09:28:59 EDT
BACKUP_MODE is for XPS (i.e. version 8 only)

Set the LTAPEDEV to /dev/null and you will have to restart the Informix
Server. Note
if you are using onbar to do your level 0 backups in parallel you are
required to have
logical logs. If you use the "-w" with onbar you are not required to have
logical logs.

John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)

admin-tools-bounces@iiug.org wrote on 07/22/2010 05:16:56 AM:

> [image removed]
>
> Stop logical log backup [3387]
>
> TRI TRINH
>
> to:
>
> admin-tools
>
> 07/22/2010 05:18 AM
>
> Sent by:
>
> admin-tools-bounces@iiug.org
>
> Please respond to admin-tools
>
> Hi,
> We are running IDS-10.00.FC6 in HP-UX11.11. In the test server, we want
to
> stop the logical log backup rotation. What is the best way to do it?
Thanks
>
>
>



>
>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3390]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Stop logical log backup
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 22 Jul 2010 08:32:48 EDT
I will try this parameter LOG_BACKUP_MODE = NONE.

We do not want to backup because of space issue.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3389]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Stop logical log backup
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 22 Jul 2010 08:22:32 EDT
I forgot to mention that we are using onbar.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3388]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Stop logical log backup
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 22 Jul 2010 08:16:57 EDT
Hi,
We are running IDS-10.00.FC6 in HP-UX11.11. In the test server, we want to
stop the logical log backup rotation. What is the best way to do it? Thanks




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3387]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dbload cannot open logging file
Posted by: smiley73@googlemail.com (Keith Simmons) - Wed, 14 Jul 2010 03:53:59 EDT
On 14 July 2010 00:53, JACKELINE LUENGAS
<jluengas@city.newport-beach.ca.us> wrote:
> I am using INFORMIX-SQL Version 11.50.FC3, in an HP-UX 11.11 OS platform.
>
> I have a problem using dbload from a 4GL script that I have used for years,
> but now it no longer works for some users, got a new version of the 4GL
> script.
>
> This is line that causes the problem:
>
> run "sh -c ' dbload -d complus -c /spi/spicps/rm8.3/doc/tvrbox.cmd -l tvrlog
> '"
>
> This is the error:
>
> Cannot open error logging file -> tvrlog
>
> Because it cannot open the log, the dbload does not load any records.
>
> I think is a permissions problem, I checked the directory permissions, the
> group permissions of all the users are the same.
>
> Any ideas out there.... thanks in advance!
>
>
>

>
>
>
>

Jackeline

Comes back to the age old problem, what has changed/been done since the last
time this ran successfully ?

Off the top of my head I can't remember whether the log from dbload is
appended
or over-writtten, however :
If all users are in the same group then the directory and file need to
be owned by
that group and permission on the directory need to be 770, 775 or 777 and on
the
file 660, 664 or 666. If the users are spread across a number of groups, or
the
directory /file are owned by a differing group then 777 and 666 are needed.

Keith




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3386]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

John Caron is in Boston at the Circuit Conference.
Posted by: John_Caron@mab.uscourts.gov (John_Caron@mab.uscourts.gov) - Tue, 13 Jul 2010 22:11:46 EDT
I will be out of the office starting 07/12/2010 and will not return until
07/14/2010.

Please contact our Boston Systems Department at 617-748-5385 for anything
requiring immmediate attention or response.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3385]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

dbload cannot open logging file
Posted by: jluengas@city.newport-beach.ca.us (JACKELINE LUENGAS) - Tue, 13 Jul 2010 19:53:09 EDT
I am using INFORMIX-SQL Version 11.50.FC3, in an HP-UX 11.11 OS platform.

I have a problem using dbload from a 4GL script that I have used for years,
but now it no longer works for some users, got a new version of the 4GL
script.

This is line that causes the problem:

run "sh -c ' dbload -d complus -c /spi/spicps/rm8.3/doc/tvrbox.cmd -l tvrlog
'"

This is the error:

Cannot open error logging file -> tvrlog

Because it cannot open the log, the dbload does not load any records.

I think is a permissions problem, I checked the directory permissions, the
group permissions of all the users are the same.

Any ideas out there.... thanks in advance!




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3384]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Automatisch: Benoit Vanderbeck is niet op kant....
Posted by: Benoit.Vanderbeck@vaph.be (Benoit.Vanderbeck@vaph.be) - Thu, 08 Jul 2010 10:00:26 EDT
I am out of the office until 19/07/2010.

Dringende vragen kan je het best richten naar exploitatie@vaph.be

Please return urgent matters to exploitatie@vaph.be

Groeten,

Benoit

Opmerking: dit is een automatisch gegenereerd antwoord op uw bericht
"sqlcmd stackdump [3382]" verzonden op 7/8/10 10:48:39.

Dit is de enige melding die u ontvangt terwijl deze persoon afwezig is.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3383]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

sqlcmd stackdump
Posted by: dirk.niemeier@stueken.de (DIRK NIEMEIER) - Thu, 08 Jul 2010 04:48:40 EDT
Hi,
I compiled sqlcmd from JL for Windows XP 32bit.
The following statement dumps while an exception occurs.

D:\Informix_DBImport>sqlcmd -u informix -p mypwd -d test 'select * from hallo'
hallo

1 [main] sqlcmd 3868 exception::handle: Exception: STATUS_ACCESS_VIOLATION

474 [main] sqlcmd 3868 open_stackdumpfile: Dumping stack trace to
sqlcmd.exe.stackdump

2775 [main] sqlcmd 3868 exception::handle: Exception: STATUS_ACCESS_VIOLATION
- 747 [main] sqlcmd 3868 exception::handle: Error while dumping state
(probably corrupted stack)

a second call generates the following:

D:\Informix_DBImport>sqlcmd -u informix -p mypwd -d test -e 'select * from
hallo'
hallo

6 [sig] sqlcmd 5484 open_stackdumpfile: Dumping stack trace to
sqlcmd.exe.stackdump

D:\Informix_DBImport>sqlcmd -u informix -p mypwd -d test 'select * from hallo'
hallo

16 [sig] sqlcmd 5532 open_stackdumpfile: Dumping stack trace to
sqlcmd.exe.stackdump

The table hallo has only one column called hallo.

Here is the core file:
Stack trace:
Frame Function Args
0022C7F8 7C802542 (0000065C, 0000EA60, 000000A4, 0022C8EC)
0022C908 610C2643 (00000000, 7C802600, 7C802542, 00000000)
0022C9E8 610BF2F7 (00000000, 00000000, 00000000, 00000000)
0022CA38 610BF70B (0000159C, 0022CA60, 00000000, 78134C58)
0022CAF8 610BF831 (0000159C, 00000006, 0022CB28, 610BF8D5)
0022CB08 610BF86C (00000006, 0022CE80, 00000000, 00000000)
0022CB28 610BF8D5 (00000000, 0022CB48, 62D03AD9, 00000009)
0022CBB8 610ED58D (00D22138, 0022CBFC, 58585858, 58585858)
0022CC68 004095B6 (00D22138, 00000020, 00000007, 00402689)
0022CD18 004030E5 (00000008, 00D08738, 00D085E8, 00000001)
0022CD98 61006E73 (00000000, 0022CDD4, 61006720, 7FFDE000)
End of stack trace

D:\Informix_DBImport>sqlcmd -h
sqlcmd: SQLCMD Version 86.00 (2008-07-15)
IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.TC6
Licenced under GNU General Public Licence Version 2 ......

I think there is a problem im my compilition. Perhaps anybody has an other
compiled Windows version?

TIA
Dirk




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3382]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Left and right outer join
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Thu, 01 Jul 2010 02:42:30 EDT
On Mon, Jun 28, 2010 at 07:07, TRI TRINH <tri_trinh@hotmail.com> wrote:

>
> select tf010.t_pdno, tf010.t_prdt, tf010.t_opno, tf010.t_tano,
> tf010.t_mcno,
> tf010.t_cwoc, tf010.t_comp, tf001.t_osta t_osta_tf001, tf001.t_mitm
> t_mitm_tf001, tf001.t_cprj t_cprj_tf001, tf001.t_pdno t_pdno_tf001,
> tf001.t_qrdr t_qrdr_tf001, tf001.t_prcd t_prcd_tf001, tr001.t_cwoc
> t_cwoc_tr001, tr001.t_dsca t_dsca_tr001, tr002.t_mcno t_mco_tr002,
> tr002.t_dsca t_dsca_tr002, ti001.t_item t_item_ti001, ti001.t_dsca
> t_dsca_ti001, tp021.t_dsca t_dsca_tp021, tp021.t_item t_item_tp021
>
> from (ttisfc010104 tf010 left outer join (ttisfc001104 tf001 left outer
> join
> ttiitm001104 ti001 on tf001.t_mitm = ti001.t_item left outer join
> ttipcs021104
> tp021 on tf001.t_mitm = tp021.t_item) on tf010.t_pdno = tf001.t_pdno) left
> outer join ttirou001104 tr001 on tf010.t_cwoc = tr001.t_cwoc left outer
> join
> ttirou002104 tr002 on tf010.t_mcno = tr002.t_mcno
>
> where tf010.t_comp = '2' AND tf001.t_osta = '7' OR tf001.t_osta = '4'
>

Which version of IDS are you using? Modern versions (11.10, 11.50) should
be able to handle that as written. If your version doesn't, you have one
more reason to upgrade.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.

--00504502ec9ad696ff048a4dc528




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3381]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Feature Request
Posted by: vonbarg@us.ibm.com (ERIKA VON BARGEN) - Mon, 28 Jun 2010 13:50:01 EDT
There is no reason why we couldn't make the seconds field of task's frequency
configurable. I will open a request for this. Thanks for the feedback!




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3380]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Feature Request
Posted by: vonbarg@us.ibm.com (ERIKA VON BARGEN) - Mon, 28 Jun 2010 13:41:14 EDT
Adding to Claus's response, there is a second place where you can also find
the logging mode of a database in OAT. In the Schema Manager, when you click
on a database name, the logging mode is displayed in the 'Information' pod.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3379]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Feature Request
Posted by: waldek@znoinski.pl (WALDEMAR ZNOINSKI) - Mon, 28 Jun 2010 13:18:44 EDT
hi there,
speaking of new features - is there a chance that there will be field with
'seconds' (to have DD:HH:MM:SS) in Frequency section in OAT -> Task scheduler
-> Scheduler -> <taskname> -> Task details?
checked with newest OAT 2.27 and no joy on that




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3378]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Feature Request
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Mon, 28 Jun 2010 12:41:17 EDT
I'm using OAT v2.27 and it certainly has the feature.
'SQL ToolBox -> Databases' has a column named 'Logging' which lists 'Not
logged', 'Buffered' and/or 'Unbuffered'.

Med venlig hilsen / Yours sincerely

Claus Samuelsen
Senior IT Specialist
IBM SWG Information Management

phone: +45 2880 3058
e-mail: csa@dk.ibm.com

From:
"JOSEPH BARIC JR" <jbaric@us.ibm.com>
To:
admin-tools@iiug.org
Date:
28-06-2010 17:50
Subject:
Feature Request [3376]
Sent by:
admin-tools-bounces@iiug.org

The one thing that onmonitor does easily that OAT does not do is display
the
logging mode of databases. Maybe we could have that displayed?






Medmindre andet er angivet ovenfor: / Unless Otherwise Stated Above:
IBM Danmark ApS
Nymøllevej 91
2800 Kongens Lyngby, Danmark
CVR nr.: 65305216




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3377]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Feature Request
Posted by: jbaric@us.ibm.com (JOSEPH BARIC JR) - Mon, 28 Jun 2010 11:49:58 EDT
The one thing that onmonitor does easily that OAT does not do is display the
logging mode of databases. Maybe we could have that displayed?




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3376]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Left and right outer join
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Mon, 28 Jun 2010 10:07:41 EDT
Art,

I got the query. Thank you.

select tf010.t_pdno, tf010.t_prdt, tf010.t_opno, tf010.t_tano, tf010.t_mcno,
tf010.t_cwoc, tf010.t_comp, tf001.t_osta t_osta_tf001, tf001.t_mitm
t_mitm_tf001, tf001.t_cprj t_cprj_tf001, tf001.t_pdno t_pdno_tf001,
tf001.t_qrdr t_qrdr_tf001, tf001.t_prcd t_prcd_tf001, tr001.t_cwoc
t_cwoc_tr001, tr001.t_dsca t_dsca_tr001, tr002.t_mcno t_mco_tr002,
tr002.t_dsca t_dsca_tr002, ti001.t_item t_item_ti001, ti001.t_dsca
t_dsca_ti001, tp021.t_dsca t_dsca_tp021, tp021.t_item t_item_tp021

from (ttisfc010104 tf010 left outer join (ttisfc001104 tf001 left outer join
ttiitm001104 ti001 on tf001.t_mitm = ti001.t_item left outer join ttipcs021104
tp021 on tf001.t_mitm = tp021.t_item) on tf010.t_pdno = tf001.t_pdno) left
outer join ttirou001104 tr001 on tf010.t_cwoc = tr001.t_cwoc left outer join
ttirou002104 tr002 on tf010.t_mcno = tr002.t_mcno

where tf010.t_comp = '2' AND tf001.t_osta = '7' OR tf001.t_osta = '4'




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3375]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Automatisch: Benoit Vanderbeck is niet op kant....
Posted by: Benoit.Vanderbeck@vaph.be (Benoit.Vanderbeck@vaph.be) - Fri, 25 Jun 2010 16:13:01 EDT
Ik ben afwezig tot 28/06/2010.

Dringende vragen kan je het best richten naar exploitatie@vaph.be

Opmerking: dit is een automatisch gegenereerd antwoord op uw bericht "Left
and right outer join [3372]" verzonden op 6/25/10 20:55:56.

Dit is de enige melding die u ontvangt terwijl deze persoon afwezig is.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3374]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Left and right outer join
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 25 Jun 2010 15:08:48 EDT
That's not valid SQL in any dialect of which I am aware. Post the entire
query and we'll try to help.

For an OUTER JOIN, left, right, or full, you need two tables. The inner
table and the outer one. You can easily translate any RIGHT OUTER JOIN into
a LEFT OUTER JOIN. Just reverse the order of the two tables. It the
relationships are more complex, use parenthesis to resolve the conflicts.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, 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 Fri, Jun 25, 2010 at 2:55 PM, TRI TRINH <tri_trinh@hotmail.com> wrote:

> Hi,
> Would some one help to translate SQL left and right outer join. Thanks
>
> FROM ITEM RIGHT OUTER JOIN
> ITEM.ITEM_CODE = PRODUCTION_ORDER.ITEM_CODE RIGHT OUTER JOIN
>
>
>
>

>
>
>
>

--0016e6da9b97e456900489df7f50




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to admin-tools@iiug.org
2. Include the bracketed message number in the subject line: [3373]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *