Threads from 2006
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Re: onspaces Segmentation Fault
paul wrote: > I have just finished reinstalling my IDS 10 for linux, on suse 9 for > workgroup. I was able to initialize the DB instance nicely (oninit -iv > ), rootdbs has been created fine. But when i type onspaces puff! it > throws > a message "segmentation fault" > > By the b…
Re: creating a trigger
THANKS! Now it works... "Art S. Kagel" <kagel@bloomberg.net> schreef in bericht news:45954922.3000003@bloomberg.net... > Art S. Kagel wrote: >> Danny De Koster wrote: >> >>> hi all!! >>> >>> last question of this year.... >>> >>> I want to use a trigger. Purpose is to keep track…
Q for Art K - Ontape restore to another server (archecker)
Re-posting as I don't want Art's idea about Gary's issue lost amongst the conceptual product design postings... Art, see below... Re-post: ------------------------------- Thanks Art, That simplifies some of the stuff we've posted on this thread, and I haven't had time for more…
Re: Ontape restore to another server
Hey Marco! > >Ian Michael Gumby wrote: > > > > > > > >> Ian Michael Gumby wrote: > >> <SNIP> > >>> Remember its not just "integers" but all words would be flipped. > >>> > >> <SNIP> > >> > >> Careful. No ALL WORDS will be flipped. Intel, unlike some old > >> little-endian chip…
Re: Ontape restore to another server
Ian Michael Gumby wrote: > > > >> Ian Michael Gumby wrote: >> <SNIP> >>> Remember its not just "integers" but all words would be flipped. >>> >> <SNIP> >> >> Careful. No ALL WORDS will be flipped. Intel, unlike some old >> little-endian chips (DEC K10/K20 chips most notably) do…
Re: Ontape restore to another server
I would put a smiley face with it but hey what do I know? :-) Happy New Year and get some new material. Ian Michael Gumby wrote: > >> > But hey! What do I know? ;-) >> > >> >> I don't know what you know, but I _am_ tired of you asking. What >> little credibility you build up …
RE: Ontape restore to another server
Thanks Art, That simplifies some of the stuff we've posted on this thread, and I haven't had time for more digging. Your way sounds the simplest. I am not very experienced with archecker (last time I played with it was years ago).... I have a couple questions for my own clarif…
Re: Ontape restore to another server
>Ian Michael Gumby wrote: ><SNIP> > > Remember its not just "integers" but all words would be flipped. > > ><SNIP> > >Careful. No ALL WORDS will be flipped. Intel, unlike some old >little-endian chips (DEC K10/K20 chips most notably) does not flip the >contents of words within …
creating a trigger
hi all!! last question of this year.... I want to use a trigger. Purpose is to keep track of changes in a table. create trigger TRIG1 after update <field> on <table> write something in a table before the word after....he gives me a syntax error has occurred.....and I don't kn…
Onspaces Segmentation fault
Hi all, I have just finished reinstalling my IDS 10 for linux, on suse 9 for workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus its mirror was created fine. But when i type onspaces (with or without the parameters), puff!!! the thing throws "Segmentat…
onspaces Segmentation Fault
I have just finished reinstalling my IDS 10 for linux, on suse 9 for workgroup. I was able to initialize the DB instance nicely (oninit -iv ), rootdbs has been created fine. But when i type onspaces puff! it throws a message "segmentation fault" By the by, the first installation…
Re: Ontape restore to another server
On 28/12/06, Sebastian, Norma J. <NormaJean.Sebastian@tellabs.com> wrote: > > I think the idea will work. I have to look at some of my systems and > remember some things. > > I am glad you said you would try this on your DEV box. Is the name of > your DEV database different tha…
RE: Ontape restore to another server
I think the idea will work. I have to look at some of my systems and remember some things. I am glad you said you would try this on your DEV box. Is the name of your DEV database different than your PRD database? And what is the name of your $INFORMIXDIR? I believe you pegg…
Re: Ontape restore to another server
>From: "Keith Simmons" <smiley73@googlemail.com> >To: "Gary Quiring" <gquiring@gmail.com> >CC: informix-list@iiug.org [SNIP] >On 28 Dec 2006 07:57:44 -0800, Gary Quiring <gquiring@gmail.com> wrote: > > Sebastian, Norma J. wrote: > > > Don't think that's different than other DB pr…
RE: Ontape restore to another server
Excellent idea Keith!! A second informix instance on the same solaris box is a great idea, informix has such a small footprint anyway. And if you PRD db is a large memory instance, you can make the second instance much smaller, restore take longer, but who cares, you don't want…
RE: Ontape restore to another server
Don't think that's different than other DB products. Use the right tool (dbexport/import like Keith said), and it'll work fine. Norma Jean Sebastian ERP Support Administration IT - Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org […
RE: Ontape restore to another server
You are going from one OS to another.... that in itself is probably a no-no. But hey, why not try... Restoring to cooked files when the backup was from raw devices should not be an issue assuming on the raw setup, you used links to point to the raw devices, and those links are…
Ontape restore to another server
I have a need to restore our production DB (9.4) to a junk box to salvage a table that recently lost some data. I am not very familiar with the steps required. The production server is running Solaris 9 with raw devices. I was hoping to restore to a Red Hat box using cooked fi…
[ANN] Ruby/Informix 0.5.0 released
Ruby/Informix is a Ruby extension for connecting to IBM Informix Dynamic Server, written in ESQL/C. It is being developed and heavily tested on Solaris/SPARC. It has been reported to work on Linux Fedora, SuSE Linux, Windows XP and HP-UX. 0.5.0 12/27/2006 ------------------ Ne…
How to identify non-system stored procedures
When I use dbschema -d database -f all I get an output containing 2011 stored procedures. A count(*) of sysprocedures yields 2350. How can I identify in the sysprocedures table just those procedures which appear in the dbschema output. Is there a flag which indicates system o…
Re: MI5 Persecution: Bizarre magazine
OTC wrote while during a drunken fit: > >MI5Victim@mi5.gov.uk said: > > > > Bizarre magazine article June/2001 > >I really wish MI5 would just kill you and be done with it ... put you out >of our misery. > >Twat. > AWww Then you'd prove him right. MI5 really did give a damn abo…
Re: MI5 Persecution: Bizarre magazine
MI5Victim@mi5.gov.uk said: > > Bizarre magazine article June/2001 I really wish MI5 would just kill you and be done with it ... put you out of our misery. Twat. -- Bye now, Obnoxio "I don't read newspapers anymore except the local rag which I do weekly to cheer myself trying …
RE: Informix 7.3 on RedHat Enterprise Linux, installation problem
> >Hi guys, I got trouble installing Informix 7.3 on a RHEL box. > >"bash: /home/informix/installserver: /usr/lib/libc.so.1: bad ELF >interpreter: No such file or directory" > >This error message keep popping out every time when I try to run the >installation scripts, all 4 scrip…
Re: 944: Cannot use "first" in this context.
Thanks to everyone here. I learn something new today. Your suggestion is very good and i really appreciate your help. Thanks again. :)…
Assign the Values to Dynamic Variable Names in SPL
How to assgin the value to Dynamic Variable Names in SPL? Something like: DEFINE l_var1 VARCHAR(255); DEFINE l_var2 VARCHAR(5); DEFINE l_var3 VARCHAR(5); BEGIN FOR i=1 tp 3 LET l_var[i] = "value" || i; -- how to assing to a dynamic variable name EN…
Re: Senior Oracle DBA now Learning Informix by Request
Double Echo wrote: > Ben, that's an interesting point you bring up. > > ISAM is the core of MySQL, which seems to be doing quite well in its > space. > > > The beauty of ISAM as a product is that it is a great entry point for > a customer to get into more sophisticated products. …
Re: ER error defining template
Andreas, thanks for the explanation. It explains Laurie's problem. But, in my example there is no "desc" keyword and the default ordering is ascending. Do you have an idea what might be the problem in this case? Thanks. Davorin "Andreas Legner" <andreas.legner@de.ibm.com> wrote…
Informix 7.3 on RedHat Enterprise Linux, installation problem
Hi guys, I got trouble installing Informix 7.3 on a RHEL box. "bash: /home/informix/installserver: /usr/lib/libc.so.1: bad ELF interpreter: No such file or directory" This error message keep popping out every time when I try to run the installation scripts, all 4 scripts, insta…
Informix 7.3 on RedHat Enterprise Linux, installation problem
Hi guys, I got trouble installing Informix 7.3 on a RHEL box. "bash: /home/informix/installserver: /usr/lib/libc.so.1: bad ELF interpreter: No such file or directory" This error message keep popping out every time when I try to run the installation scripts, all 4 scripts, insta…
Informix User Forum 2006 - Pictures and Presentations are on the website
The Informix User Group Technical Conference - Friday and Saturday, December 8-9, 2006 The Washington Area Informix User Group (WAIUG) based in Washington, DC, and the Southeast Informix Users Group (SEIUG), based in Atlanta, GA, teamed up once again to present Informix User For…
RE: Informix DBA Training
p.s. welcome aboard ! Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Dave Sent: Tuesday, December 26, 2006 6:10 PM To: inf…
RE: Informix DBA Training
Perhaps the app vendor might offer some. By this i mean if you are admin'ing informix under SAP or some well known application, they may offer training courses. I know it's not before February, but you may want to go to IIUG/IDUG 2007 conference in May. Hunt around on.... http:…
Informix DBA Training
Good evening all, I am a new (6 months) DBA for Informix. I am looking to get training on Database Administration. I would like to get training sooner than February 2007 (Advanced DataTools & IBM offer training in February). Does anyone know of any courses being offered befor…
944: Cannot use "first" in this context.
Hello, In my stored procedure, there is a sql: select first 1 sales_emp_key, end_customer into t_sales_emp_key, t_end_customer from delivery_fact where order_number = t_order_number and item_number = t_del_item_num; which caused problem. Below is the error message th…
Re: ER error defining template
It is the 'desc' in the 'create unique index' statement which is causing this error at master replicate creation. I've logged a new bug for this. Andreas…
Re: ER error defining template
It is the 'desc' in the 'create unique index' statement which is causing this error at master replicate creation. I've logged a new bug for this. Andreas…
RE: Senior Oracle DBA now Learning Informix by Request
And I never heard of timesten until you started talking about it. Querying oracle.com..... oh, it's something they bought. So you jest at IBM for buying informix...... How is that different than oracle buying timesten? Aren't they such a powerful omnipotent database vendor they…
FW: PRL Status
We've got a perl/DBD application that we've copied over to another system. The perl/DBD expert - of course - is no longer with the company. Any idea on where to start debugging this? TIA. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -…
Re: Senior Oracle DBA now Learning Informix by Request of Company: I Thought Informix was Dead?
cfoughty@gmail.com wrote: > So I've been doing Oracle for almost 20 years now and I've been > assigned to learn Informix IDS so I can become a backup Informix DBA. I > thought when IBM acquired Informix they would kill it and move > everybody to UDB (DB2 for non-mainframe). So wh…
Re: Senior Oracle DBA now Learning Informix by Request
006 14:16:47.0987 (UTC) FILETIME=[D11ACC30:01C725D3] > > >DA Morgan said: > > How about TimesTen running one hundred times faster than that? > >Yes, but TimesTen ISN'T Oracle's core database. > >-- >Bye now, >Obnoxio > Sigh. I wasn't going to comment on this, but since Daniel wa…
Selling PHP Scripts
Selling PHP Scripts www.digishop.altermedica.net…
ontape quits with error
Hello, we are just facing a problem of maybe ontape or something else: we have two servers, one on a hpux11 system another on a SUSe linux both IDS version 10.00. with dbaccess on linux I transfer a complete database from hpux. After a while the logs run full and the transfer sto…
Re: interrupting a running sql statement in python
On Tue, 2006-12-19 at 13:31 -0600, Andrew Ford wrote: > Does anyone know if any of the Informix modules for Python allow you to > interrupt or time out a long running query? ESQL/C appears to have this > functionality via the sqlbreakcallback () function. > > Thanks, > > Andrew …
Getting something out of a DBS...
Hi fellow DBAs, I have a nice 1Gb DBS named dbs940. I guess you'll understand which version it comes from. The guy in charge of backup simply "copied" the DB Space. Now, I'd like to recover the data. Before tempting any stupid thing, is there something I can do to open it with …
The Full What Oracle Users think
http://www.oninit.com/article/newstracker.php?id=22 Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com Growing Old is Mandatory Growing Up is Optional Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more informati…
C UDR : Text to Char or reverse
Hi all, i implented some c-udr's in ids 10 successfully. The new request is to cast text-fields (simple large objetcs) and/or reverse. Main-problem is to cast TEXT-Field to the lvarchar-type. IBM-Doc and IDN says : you can't use text-fields in udr's but as arguments to routi…
Questions about triggers...
When you have cascading triggers, are they synchronis or asynchonis in nature. Scenario: You have end user (Fred) inserts a row in to table foo an after insert trigger tfoo is called. tfoo then inserts a row in to a second table called bar_queue. An after insert trigger calle…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
Mark Townsend schreef: > Well - what about multiple production and development instances on 2 big > Superdomes with around 65 TB of managed storage between them, with 2 > DBA's ? Close enough ? Ex Informix customer by the way. > how about informix running faster on a 5 times sma…
Informix vintage artwork
Hi, I am working on a new video/flash project and I would like to increase my library of Informix "vintage" artwork, like logos, etc. You may have seen the last one @ http://www.youtube.com/watch?v=e9Dbu9w5zEs... The most I get the richer the video will be ;-). Ideally if you …
RE: Senior Oracle DBA now Learning Informix by Request
So you personally know Obnoxio? > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of DA Morgan > Sent: Thursday, December 21, 2006 03:32 > To: informix-list@iiug.org > Subject: Re: Senior Oracle DBA now Learn…
Re: Time zone
select dbinfo('get_tz') from table(set{1}) > Krystian wrote: > > Hi, > > > > how to determine in SPL/SQL time zone the client has or the server is > > into? > > It doesn't matter to me which one, as they are both the same. > > I just don't want to create another spl routine just…
Problem on IDS 7.31 with Raw Device and SCO
Dears, I have 1 machine with the SCO and Informix 7,31 using Raw Device. My database has 3 dbspaces (rootdbs, dbspactemp, dbspace1). All chunks are in raw device. Dbspace1 and all its 5 chunks are offline. When I try to change the status for on-line the IDS returns error "0".…
Re: Happy Holidays!
On Wed, 20 Dec 2006 04:36:57 -0600, "Paul Watson" <paul@oninit.com> wrote: >> On 19 Dec 2006 05:11:00 GMT, David <dwfraser@gnospammail.com> wrote: >> >> >Which translates as "I love Informix... and adore IBM" Thanks DE. >> > >> >:-) >> > >> >Merry Christmas to all aussies, poms…
Re: Senior Oracle DBA now Learning Informix by Request
> > > > I stand correct. Simply put ... the fact was, for rather obvious > > reasons, not common knowledge at Microsoft and not in their best > > interests to acknowledge. > > > > I am aware of quite a few other companies use competitor's software > > that, for similar reasons, t…
Re: Senior Oracle DBA now Learning Informix by Request
Do you get your best thinking on your first or second pint? Just curious. :-) Anyway... first or second pint, who cares. I thought of "Orcanauts". It incorporates the brand(tm) with the identity. 8o) Obnoxio The Clown wrote: > Double Echo said: >> Wow. Codernauts... you'd…
RE: Something for Xmas
Sebastian, Norma J. said: > > It must be those 9% that experience no unplanned downtime that make the > 9% revenue numbers? > > How about those double-digits ;) > 24% 1-5 hrs unplanned downtime, > 12% 5-10 hrs " > 13% 10-24 hrs " > 12% 24+ hrs unpla…
RE: Something for Xmas
It must be those 9% that experience no unplanned downtime that make the 9% revenue numbers? How about those double-digits ;) 24% 1-5 hrs unplanned downtime, 12% 5-10 hrs " 13% 10-24 hrs " 12% 24+ hrs unplanned downtime -----Original Message----- F…
Onbar Pools and File System with ISM
Hi Folks, I got a IDS 9.40 UC5 on Red Hat Enterpirse 3. I´m trying to implement the onbar archive utility and wish that it could be make to disk. I already did it with ontape utility, but is so easy. The ISM configuration is my problem. I couldn´t see clearly what is each param…
RE: PL/Ruby for Informix
On Wed, 2006-12-20 at 15:48 +0100, Jean Georges Perrin wrote: > Carsten, > > As I told u in D.C, why don't you simply "wrap" the standard object & > instances in the static method? Yes, I know that that's an option. I haven't actually tried this yet because I don't have a use ca…
RE: PL/Ruby for Informix
Carsten, As I told u in D.C, why don't you simply "wrap" the standard object & instances in the static method? (I was thinking about doing it for EGL, so that you can write EGL stored proc ;-) ). jgp > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:…
OT: Re: ER error defining template
OK, maybe not totally off topic. Last week I've had somewhat similar situation. Here are the details. ER setup in primary-target scenario. HP-UX B.11.23 ia64 + IDS 10.00.FC4 Solaris 9 (Sparc) + IDS 10.00.FC4X5 Customer tried to "cdr check" the replicates (checksum routines succe…
RE: PL/Ruby for Informix
Oh stop. Picking on DA is a probably a hobby for most. ;-) >At least it belongs to Informix, there were so much Oracle-support posts >lately, I had doubts... > Yeah, well I could have sworn that there is such a beast already. (Let me know cause I'm going to start playing with …
RE: Senior Oracle DBA now Learning Informix by Request
Where in my post did I say it was Microsoft SALES that set me up with the long technical database call to Redmond? It wasn't. I do not talk to sales people for long, I pass them off to other people who like that kind of "soft" talk.... "soft" talk doesn't keep servers, database…
RE: Senior Oracle DBA now Learning Informix by Request
Oracle sells something for a $1 or $2....... wow, you must have some good drugs. Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Beha…
RE: Senior Oracle DBA now Learning Informix by Request
Thanks Obbie, I was confused by Daniel's smartarse response especially since I have been known to defend him as he has been quite helpful when I have posted for help in the Oracle forums. Here I was merely using my admittedly limited knowledge about oracle to offer oracle's own…
Time zone
Hi, how to determine in SPL/SQL time zone the client has or the server is into? It doesn't matter to me which one, as they are both the same. I just don't want to create another spl routine just to determine this /well i hope i won't have to/. Best regards, Krystian…
cdr repl sync and shadow replicates
Does anyone know if the shadow replicates created during a cdr sync repl will be automatically deleted or will I have to manually remove them? If they are removed automatically, when are they removed? I still see them hanging around on the target servers that were sync'd. This…
Re: How to prevent user connect with ids
Eric Rowell 寫道： > Other option... Man I cannot belive I forgot it... Then again I > don't know if it is an option in AIX 5.2 (it is in AIX 5.3). > > Start Filters and the highest level for getting to configurations; > smitty ipsec4 > smitty ipsec6 > > More Options to allow for…
Re: Happy Holidays!
On 19 Dec 2006 05:11:00 GMT, David <dwfraser@gnospammail.com> wrote: >Which translates as "I love Informix... and adore IBM" Thanks DE. > >:-) > >Merry Christmas to all aussies, poms, eurowhatsits, and residents of the >axis of good and evil. And the Yanks would be . . . . . .…
Re: Senior Oracle DBA now Learning Informix by Request
>> >>Daniel, >> >>Whether by intent or by defect, you're definitely not the sharpest tool in >>the shed. >> >>First you lose points cause you don't understand about language theory. >>You posts on PL/SQL go nowhere and don't address the key points. >> >>Second you don't understan…
PL/Ruby for Informix
I'm planning to write PL/Ruby for Informix. I've made some research and found that I need to implement a UDRLM (User Defined Routine Language Manager.) There's nothing about creating a UDRLM in the manuals: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp Googlin…
Re: Senior Oracle DBA now Learning Informix by Request
>Ian Michael Gumby wrote: >> >>Clearly simple toys for simple boys. >> >>Too bad the market doesn't agree with you. >> >>>> >>>TimesTen is awesome. I am a Beta Tester for version 7 and it is truly >>>amazing. >>> >>>Obviously I am under an NDA so I can't talk about what I am doin…
Re: Happy Holidays!
Double Echo wrote: > "Please accept with no obligation, implied or implicit, my best wishes for an environmentally conscious, socially responsible, low-stress, non-addictive, gender-neutral celebration of the winter solstice holiday, practiced within the most enjoyable traditions…
RE: Senior Oracle DBA now Learning Informix by Request
The Microsoft Chicago office is woefully out of the loop...... They set me up with a nice long phone chat with a guy at the Redmond office.... by golly, I could have sworn we spent several hours discussing how he ran SAP for Microsoft on Sqlserver (not oracle). I know I fantasiz…
RE: Senior Oracle DBA now Learning Informix by Request
Per Oracle.... http://www.oracle.com/corporate/press/2006_dec/q2fy07-rls.html?msgid=522 1196 Oracle Press Release Contact(s): Krista Bessinger Oracle Investor Relations Bob Wynne Oracle Corporate Communications ORACLE REPORTS Q2 GAAP EPS UP 20% TO 18 CENTS, NON-…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:45872C40.30901@bloomberg.net... > How about every base of one branch of a certain major country's military > with an Informix instance and no DBAs. Er, I'm not sure I like the implications of that one! Unless it's Franc…
Re: Invalid characters in LVarChar field
You could look at the regexp blade but I've not tried it for searching for NULLs but it can detect control characters Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com Growing Old is Mandatory Growing Up is Optional Attend IDUG 2007 San Jose,…
RV: Query lento
ªçjYè®÷«¶^ .ènW¦iÊ'ºz®z¼ª¹ç.jwh£yË¡éî…
Informix Update Triggers
Hello, I have a need to execute a stored procedure conditionally based on a specific column and it's new value. The current debate is the use of a WHEN clause in a FOR EACH ROW, as opposed to UPDATE FOR column_name in the trigger declaration. [INFORMIX environment] My position …
Informix Update Triggers
Hello, I have a need to execute a stored procedure conditionally based on a specific column and it's new value. The current debate is the use of a WHEN clause in a FOR EACH ROW, as opposed to UPDATE FOR column_name in the trigger declaration. [INFORMIX environment] My position …
informix upgrade to V10
Hi all, We have one machine A is running Informix (V7.31) on Aix 4.3. We are planning to migrate to machine B which will run Informix (V10) on Aix 5.3. I am looking for advice to how to get it done. I was thinking to do mksysb migration, which can use mksysb tape(V4.3) with AIX …
interrupting a running sql statement in python
Does anyone know if any of the Informix modules for Python allow you to interrupt or time out a long running query? ESQL/C appears to have this functionality via the sqlbreakcallback () function. Thanks, Andrew…
VP error
IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…
Invalid characters in LVarChar field
IDS: 9.4 FC3 O/S: HPUX 11.11 We have a .NET app that uses log4net to write application exceptions to our database to help debugging. However when it inserts the .NET exception, it inserts nonprintable/invalid characters between each and every letter of the exception. It makes …
Re: SAN Layout Question...
Tam, If you balance your jobs on physical disks(dbspaces) well, I do not see other options. We also stripped the disks to give a more parallelism. By the way, UC5 improved a fragmentation problem, now much faster. Frank On 12/18/06, Tam O'Shanter <tam@oshanter.com> wrote: …
ER error
Hi, Madison and other experts, I have defined new replication servers thousands times without any issues for a couple of years! From yesterday, I was going to setup a ER in a new box, when I run the command, it displayed, informix@otto $ cdr define server --init ncdcprd_grp co…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166496957.776051@bubbleator.drizzle.com... > >> I know for a fact that I was correct. The MS employee was doing what >> I would expect them to do or may not have been aware of the facts. >> Either way I…
RE: Daylight Savings Time in 2007
And also http://www1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHM MC&context=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=S SGHZP&context=SSVT2J&dc=D600&uid=swg21248851&loc=en_US&cs=utf-8&lang= I haven't had any luck getting the jtzu thing to work…
RE: Just to put things in perspective.
I am glad I don't have Oracle's stock... Last time they missed the "prediction"... ;-) > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Ian Michael Gumby > Sent: Tuesday, December 19, 2006 17:06 > To: inf…
Just to put things in perspective.
This was taken from el Reg. ;-) "New software sales rose just 14 per cent year-over-year. Wall Street hoped Oracle could push that figure to between 15 per cent and 20 per cent. New database and middleware licenses rose 9 per cent - a drop from the first quarter - and new applica…
Daylight Savings Time in 2007
This was sent to me earlier - Is there a link or patch specific to Informix out there that someone is aware of? Thanks in advance - Tom =================== Following describes the problem we might face: In the United States the start and end of daylight savings times are being …
Informix wont run
we have an HP K580 running HPUX 11.0, IDS 7.31.ud6 and react2001 application. the disk drive housing the informix database failed. it was replaced and an archive tape backup was run to restore the data. the OS and application started on boot, but informix isn't running and will n…
Dbload and Load: Maximum File Size
I seem to remember there perhaps being a maximum file size or record count and want to do if I need to start figuring out ways to make my unload files smaller. I have blobspaces over 16 GB in size and some normal tables that I believe will be over 2GB in size when unloaded. As I …
Re: ER error defining template
There is a primary key Table schema follows: create table 'informix'.action ( a_employee_id CHAR(6) not null, a_loworg CHAR(4), a_schedule_cd CHAR(2), a_pos_id CHAR(8), a_job_title CHAR(50), a_auth_job_id CHAR(6), a_job_id CHAR(6), a_dps_eff_dt D…
Re: How to prevent user connect with ids
Other option... Man I cannot belive I forgot it... Then again I don't know if it is an option in AIX 5.2 (it is in AIX 5.3). Start Filters and the highest level for getting to configurations; smitty ipsec4 smitty ipsec6 More Options to allow for configurations; smitty ips4_ad…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude said: > You are nothing but a lying scum. Man you have some nerve. > Not only you lied, you still insist on it. Daniel is utterly shameless. He made a fool of himself with the Wigwam Depot and then made out like someone else was stupid. He has done things like that be…
About the programming of VB
Greetings, How can I write 'SQL_ATTR_QUERY_TIMEOUT' with VB and VC ? Or, do you have any sample ? Please introduce it to me. best regard , maxa…
Bringing primary chunk online
Hi all, Am trying to bring an a primary chunk online but am gettig the following error message; My command is : onspaces -s rootdbs -p /netapp/rootdbs -o 0 -O WARNING: bringing a down chunk into recovery state. Do you really want to continue? (y/n)y Verifying physical disk spa…
Re: Happy Holidays!
Which translates as "I love Informix... and adore IBM" Thanks DE. :-) Merry Christmas to all aussies, poms, eurowhatsits, and residents of the axis of good and evil. BTW. Kiwis rule. :-) Double Echo <doubleecho@your.com> wrote in news:yrDhh.26996$vp6.20551@fe07.usenetserve…
ER error defining template
HPUX 11.11 IDS 10.00 FC5 I am new to ER, but have successfully defined and realized several templates. On my last endeavor, I got this error Obtaining dictionary for personnel@g_psproda:''informix''.action Not all columns in PK are selected for repl command failed -- An error…
Re: How to tell if a report was started
On 18 Dec 2006 15:40:16 -0800, kimmerkc <kkohler@peapod.com> wrote: > I have a 4GL (7.13) app that makes use of several different reports 7.31? AFAIK, there never was an I4GL 7.13. There was an IDS 7.13, but you should *not* be using it still - and that has been true for a dec…
Re: Received wisdom
On 12/18/06, Clive Eisen <clive@serendipita.com> wrote: > Does anyone have benchmarks/wisdom relating to the following? > (Informix Dynamic Server Version 10.00.UC3R1TL on Linux) > > I have to insert 40M numbers into a table in a logged database > > The target table has a unique …
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166462391.363644@bubbleator.drizzle.com... > >> You don't understand what the technology is. You don't understand >> what the technologies does. You don't have the capability to >> duplicate it in Infor…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166462391.363644@bubbleator.drizzle.com... > >> You don't understand what the technology is. You don't understand >> what the technologies does. You don't have the capability to >> duplicate it in Infor…
Re: Senior Oracle DBA now Learning Informix by Request
Isn't Daniel the guy they use in the game Wolfenstein that says in a British accent, "Well Played!" ? *<8o) Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166462391.363644@bubbleator.drizzle.com... > >> You don't understand what the technology is…
Re: Senior Oracle DBA now Learning Informix by Request
Ian Michael Gumby wrote: > > > To clarify, the analysts expect "double digit" growth from IBM SWG IM > pillar as well as this from Oracle. Its when they don't see double digit > growth that they get concerned. > Ian - I saw the reference you provided for double digit Informix g…
Re: Senior Oracle DBA now Learning Informix by Request
Serge Rielau wrote: > DA Morgan wrote: >> Are you saying that the moral imperative at IBM is "we don't do it >> until Safra does it first?" > I live by the rule that before I ask others to do something I make sure > I do it myself. > I am not asking Oracle to break out their reve…
Re: Senior Oracle DBA now Learning Informix by Request
Double Echo wrote: > So.... what were you _really_ trying to say? > > *<8o) I think that's he's insecure about something and has a lousy sense of humor. <g> Regards until next we again meet on the field of play Obnoxio. > Obnoxio The Clown wrote: >> DA Morgan said: >>> Obnoxio…
Re: How to prevent user connect with ids
Uhm yeah that would work. If you don't have any TCP/IP connection defined in your $INFORMIXDIR/etc/sqlhosts that would be the safest if you don't want *ANY* outside connection. The major drawback would be if you had a 4gl app that was on another machine.... Another solution wou…
Re: Multiple Reports to One File
kimmerkc wrote: > Obnoxio The Clown wrote: > > >>Before you run the report: >> >>RUN "> filename" >>... >> >>Then: >>START REPORT items TO PIPE "cat >> filename" >>... >> >>START REPORT containers TO PIPE "cat >> filename" >>... >> >>? >> > > Thank you! > > One further question. …
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
Mark Townsend wrote: > Art S. Kagel wrote: > >> >> I find it telling that you are not even willing to say "Yeah I will >> certify that there are similar customers using Oracle with thousands >> of servers with fewer than 20 DBAs also." but resort to discounting my >> own assertio…
How to tell if a report was started
I have a 4GL (7.13) app that makes use of several different reports based on various circumstances in the data. The application has a general error function that is accessed via "WHENEVER ERROR CALL error_function" at the start of the MAIN body of the app. I would like this err…
Re: Happy Holidays!
For once DE you posted something worth reading. :) That's some funny stuff right there. Merry Christmas to you too. ----- Original Message ---- From: Double Echo <doubleecho@your.com> To: informix-list@iiug.org Sent: Monday, December 18, 2006 3:10:52 PM Subject: Happy Holidays!…
Happy Holidays!
"Please accept with no obligation, implied or implicit, my best wishes for an environmentally conscious, socially responsible, low-stress, non-addictive, gender-neutral celebration of the winter solstice holiday, practiced within the most enjoyable traditions of the religious per…
SAN Layout Question...
Greetings, I am working with IFX 10UC4 and migrating data to an EMC SAN. We currently have 2 LUNS available for use with our IFX database. The LUNS are setup to use RAID 1+0. Machine has 8 dual core processors. The database is approximately 300GB, however, through the use of…
Multiple Reports to One File
Hello, I am trying to generate a report to a flat file that consists of two very different sections. Like so: HEADER... Item Info... Item Info... Item Info... Item Info... Container Info... Container Info... Container Info... FOOTER... The Item and Container records are not l…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166401364.229016@bubbleator.drizzle.com... >> Tambi Dude wrote: >>> "DA Morgan" <damorgan@psoug.org> wrote in message >>> news:1166388023.574809@bubbleator.drizzle.com... >>>> How one defines quality is…
RE: Senior Oracle DBA now Learning Informix by Request
As long as those training classes involve travel ;) Alas, I would not be allowed to travel for Oracle training.... I can go downtown Chicago for it. But I am going to San Fran for SAP DB2 training! -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informi…
Re: Senior Oracle DBA now Learning Informix by Request
DA Morgan wrote: > Ian Michael Gumby wrote: > >> As I stated in an earlier post, analysts do want to know the breakdown >> by product. With respect to Oracle, they only have one database >> product line. > > This is not true and likely will lead to questions about revenue at > Or…
Re: Senior Oracle DBA now Learning Informix by Request
elanleblanc@yahoo.com wrote: > Obnoxio The Clown wrote: > >> What does a RAC cluster give you that I can't get in Informix some other way? >> > An administrative headache? > More training classes for N-J. More DBA friends. Higher salary to buy a bigger house. How could any CFO r…
Received wisdom
Does anyone have benchmarks/wisdom relating to the following? (Informix Dynamic Server Version 10.00.UC3R1TL on Linux) I have to insert 40M numbers into a table in a logged database The target table has a unique index on this column The source data has duplication. Is it fast…
Re: WAIUG follow-up
I just did a lookup on on the presentations from the WAIUG user forum 2006 here: http://www.iiug.org/waiug/present/Forum2006/Forum2006.html However the presentations from the keynote speakers (Ambug Goyal and Arvind Krishna) seem not to be listed there. What is the reason for …
Re: Senior Oracle DBA now Learning Informix by Request
elanleblanc@yahoo.com said: > > Obnoxio The Clown wrote: > >> What does a RAC cluster give you that I can't get in Informix some other >> way? >> > An administrative headache? You can fake that by making a mess of your disk allocations though. :o) -- Bye now, Obnoxio "I don't …
how to start a transaction log
I am running dbaccess and then running command ' begin work', the error message I get is : 256: Transaction not available. so I find the error with finderr 256 that I must start a transaction log. Could u help to give me solution how to start a transaction log? IDS 9.40 FC5 HP-U…
How to prevent user connect with ids
Hi, MY box is ids 9.40 on AIX 5.2. How can I make a user that he can telnet to the AIX and run 4gl program, But prevent him from connecting to the informix server from Delphi & client -sdk ?…
Re: Merry Xmas Pommy Bahstads
Tambi Dude wrote: > > Welcome back Andrew. long time. Indeed it is. I haven't had much call to deal with the Informix for a few years now. It just keeps .... running! > This ashes is a complete grudge series. Poor Pommies. > They have to pay a heavy price for having the temerit…
Re: Senior Oracle DBA now Learning Informix by Request
Daniel, Does the Oracle DBA Certification still require some kind of "time in service" requirement before certification is allowed? I read a while back you can't just sit for the test, you actually have to have some time as an Oracle DBA before you can get certified. Is this t…
Re: Senior Oracle DBA now Learning Informix by Request
>Ian Michael Gumby wrote: > > > As I stated in an earlier post, analysts do want to know the breakdown > > by product. With respect to Oracle, they only have one database product > > line. > >This is not true and likely will lead to questions about revenue at >Oracle at some poin…
Merry Xmas Pommy Bahstads
Q: What has Geraint Jones got in common with Michael Jackson? A: They both wear gloves for no reason. Q: What do you give Harmison to make sure the next ball takes a wicket? A: A bat! Q: What's the easiest job to have on the England team? A: The guy who sands the ball marks off…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166388023.574809@bubbleator.drizzle.com... >> How one defines quality is critical. You likely rate Informix quality >> on what it can do. I might rate it on what it can not do. Anytime you >> succeed in…
Re: Senior Oracle DBA now Learning Informix by Request
elanleblanc@yahoo.com wrote: > Obnoxio The Clown wrote: > >> What does a RAC cluster give you that I can't get in Informix some other way? >> > An administrative headache? Jealous? <g> -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to re…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166114534.310354@bubbleator.drizzle.com... >> Tambi Dude wrote: >>> "DA Morgan" <damorgan@psoug.org> wrote in message >>> news:1166054192.895791@bubbleator.drizzle.com... >>>> Obnoxio The Clown wrote: >…
Re: Senior Oracle DBA now Learning Informix by Request
Mark Townsend wrote: > >> >> 5. Informix license revenue is growing by double digits. A clear >> indicator of a product dying is double digit growth. >> > > Please provide a cite for this statment No doubt it will include a list of the many schools teaching Informix skills too…
Re: Senior Oracle DBA now Learning Informix by Request
Andrew Ford wrote: > ----- Original Message ----- > From: "DA Morgan" <damorgan@psoug.org> > Newsgroups: comp.databases.informix > To: <informix-list@iiug.org> > Sent: Thursday, December 14, 2006 2:13 PM > Subject: Re: Senior Oracle DBA now Learning Informix by Request > > >> And…
Re: A way to get autogenerated keys
It is all there the media center is very complete and very good. Doug Lawry wrote: > Well found! I didn't know Client SDK and JDBC were covered in the Infocenter. > > "bozon" <curtis@crowson1.com> wrote in message > news:1166107197.017917.88770@80g2000cwy.googlegroups.com... > >…
Off topic WAIUG: Anyone else pay 16$US for a 1min call to Europe from the Marriott?
.. just discovered this on my phone hotel bill and went ballistic. If it happened to you, the more people call an raise hell the better: 301 380 3000 Marriott Guest relations 866 435 7627 Billing (hey I saved 8 bucks, wohooh ;-) I learned that $16.14 is AT/T operator assist (not…
apply TX logs after data migration
We are planning a migration from from one platform to another (both Intel/Redhat, IDS 10.00.UC4, new one is bigger, faster, stronger, etc....). We want to do the migration from a staging server to: - leave production up - move only 1 years worth of data; leave historical data beh…
WAIUG follow-up
All, Following WAIUG, here are my latest postcards... http://www.db2mag.com/postcards3.shtml Cheers, jgp…
RE: Just to point out the obvious... ;-)
> ..., just look at > Serge. Oh No! > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Ian Michael Gumby > Sent: Friday, December 15, 2006 17:40 > To: srielau@ca.ibm.com; informix-list@iiug.org > Subject: …
odbc Error - Not enough space for parser stacks
Hi, We have web application developed in Microsoft .net technology and uses odbc.net driver to connect Informix server (IDS 9.4 TC3) running on windows 2000 server. Sometimes in application logs I see error message during executing query. >>>>>Inner Exception : Message= ERROR […
Re: Raw chunks names script
select * from syschunks, sysdbspaces where sysdbspaces.dbsnum = syschunks.dbsnum and nxchknum =0 and dbsname = <insert dbsname here> That should get you everything you need ot know about the last chunk in a given dbspace --------------------------------------------------------…
Raw chunks names script
Does anyone have a script that will give me the name of the last chunk for a dbspace, I had a look in the repository but didn't see anything obvious Regards Colin There are 10 types of people in the world, those that understand binary and those that don't ____________________…
RE: Disable Constraint
I used the correct method, I don't do hacks through the catalog, I just wanted to know what happens when executing SET CONSTRAINT <name> DISABLED Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Urich Ann" <Uri…
Re: Senior Oracle DBA now Learning Informix by Request
Mark Townsend wrote: > Sebastian, Norma J. wrote: >> Is training dollars spent a valid comparison? >> > > I think so and in fact used to use this as a comparison metric (and > still do). But to get around any vendor skew I would compare the DBA > training offered by third party c…
Re: Duplicate check
This is kind of wrong in the sense that of course you can't have duplicate primary keys. I was tired when I answered this last night. So you put all of the parts of the key fields and the non-key field togethers that make up the duplicate case. In your case it looks like key part…
Re: Senior Oracle DBA now Learning Informix by Request
Mark Townsend wrote: > >> >> 5. Informix license revenue is growing by double digits. A clear >> indicator of a product dying is double digit growth. > Please provide a cite for this statment Slides presented by Ambuj Goyal GM of IBM Information Management last Friday 8:am at t…
problem while accessing informix on local machine.
Hi, I had recently installed an informix server on a local machine and used the aquafold studio to access data in it - my OS is Win XP Pro SP2. While this seemd to work for 2-3 days , since yesterday i get an error message which inside the 'informix.log' file of the db states : …
RE: Senior Oracle DBA now Learning Informix by Request
Sebastian, Norma J. said: > > I've never done a cold backup with Informix......Have had to play some > games at small companies with limited tape drives back in the early > 90s.... but no cold backups. Still know Oracle databases that are both > backed up and fully exported each…
Re: Senior Oracle DBA now Learning Informix by Request
Mark Townsend said: > >> Mark was very insistent that >> the argument here was that Oracle is no harder to administer than IDS. > > Mark was very insistent that it's never been proven that Informix is > easier to own or operate than Oracle. So, in private, Mark actually admits …
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
Mark Townsend said: > Hmm - I don't think even Serge would agree with this statement. > Procedural code has it place both within and extant to the database I was thinking more of another IBMer, guy called Codd -- heard of him? -- Bye now, Obnoxio "I don't read newspapers anymo…
Re: Senior Oracle DBA now Learning Informix by Request
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.573.1166117478.29126.informix-list@iiug.org... > > DA Morgan said: >> What I find fascinating is that someone who, at least in theory, makes >> his money improving a product to force DBAs into the unemplo…
Re: Senior Oracle DBA now Learning Informix by Request
Guy Bowerman, a senior software engineer in IBM's Resolution Engineering and Development Team, has stated this fact for Q2 and Q3 in his blog. http://www-03.ibm.com/developerworks/blogs/page/gbowerman?tag=sales Bruce Weed, Program Director for IBM Data Servers, states double di…
Re: Senior Oracle DBA now Learning Informix by Request
> All right. Let's take big box chains. > Something in the order of Ceiling*Mart or The Wigwam Depot. I did some quick research on Home Depot with google. Seems they are pretty happy to reference for other technology vendors (DataDirect, BMC, Verity). They have done a podcast wi…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
Art S. Kagel wrote: > > I find it telling that you are not even willing to say "Yeah I will > certify that there are similar customers using Oracle with thousands of > servers with fewer than 20 DBAs also." but resort to discounting my own > assertions and those of others instea…
Re: Senior Oracle DBA now Learning Informix by Request
> > Mark claims that Informix is no easier to administer than Oracle, so we > want to be shown that. > I never made any such claim. I said the argument that Informix was easier to manage than Oracle was an old chestnut and has never been proved.…
RE: Senior Oracle DBA now Learning Informix by Request
I'd have to defer to the Informix people out here who know more history than I. I've never done a cold backup with Informix......Have had to play some games at small companies with limited tape drives back in the early 90s.... but no cold backups. Still know Oracle databases tha…
Re: Senior Oracle DBA now Learning Informix by Request
Serge Rielau wrote: > There must be some big box store somewhere running their operation on > Oracle? There are plenty to go around: > Future Shop, JC Penny, Sears, HBC, Target, Wal*Mart, The Home Depot, > Rona, Canadian Tire, ... > Wasn't Oracle making a big fuss about having K…
Re: Senior Oracle DBA now Learning Informix by Request
> I recently worked for The Wigwam Depot as an Informix DBA. We maintained > 6000+ Informix instances in 2000+ retail locations and 100+ corporate > Informix instances with 2.5 full time Informix DBAs (2 full time DBAs and a > Team Lead who split time between IDS administration …
RE: Senior Oracle DBA now Learning Informix by Request
3rd party training vendors...... no please, I have not experienced good Oracle training from 3rd parties. (yes, in my various attempts to understand Oracle, mostly I have taken classes from Oracle. I had one Oracle class from a 3rd party and they were not well equipped to answe…
RE: Senior Oracle DBA now Learning Informix by Request
Ah, supported versions of Oracle.... I ignore Oracle desupport (or obsolence or whatever they are called now) and patch notices because there are too many and I can't get downtime that frequently. In this way Oracle is sort of like Microsoft (who came up with this strategy first…
Active Users
Our auditors have asked that I provide the following: System generated listing of active Informix users (with their access permissions), as well as a system generated listing of Informix administrators. Is there such a listing? How do I generate such a listing? IDS 9.40.FC3 HPU…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
> >DA Morgan said: > > Then why all the criticism of PL/SQL being clunky. > >Because it's not relational. > >-- >Bye now, >Obnoxio Since I'm the one who said that PL/SQL is clunky... It is clunky. Ok, all SPLs are pretty clunky because they weren't really well thought out. I …
Duplicate check
IDS: 9.4FC3 O/S: HPUX 11.11 I am trying to determine the best query to use for a view showing only duplicate records. fields in view char(1),smallint,char(2),int, date (which together are the pk of table) I'll call these fields 1-5 Duplicate checking fields are 1st 4 from pk (…
JDBC license query
Hello A potential customer of mine is running Informix and I want to approach them with a proposal to develop software for them which would connect to their Informix DB using JDBC. I understand that the JDBC client and server ships with Informix and a trial version is available t…
RE: Senior Oracle DBA now Learning Informix by Request
Ok.... I guess I should maybe take this back.... Oracle is probably better at Informix with persuading people they "need" to go to class.... and I was dumb enough to get sucked in..... then the class wasn't so clear so I had to go to another, and another, and another..... Which…
Re: Senior Oracle DBA now Learning Informix by Request
Andrew Ford said: > We maintain 18 24/7 Informix > instances with .5 full time Informix DBAs (I split my time between DBA, > development and sysadmin work). But that's still just anecdotal evidence. :o> -- Bye now, Obnoxio "I don't read newspapers anymore except the local rag…
RE: Senior Oracle DBA now Learning Informix by Request
Is training dollars spent a valid comparison? Every version of Oracle seems to require new training classes (above and beyond the "new features class" whose purpose appears to be a sales pitch for other classes)..... It appears that as Oracle changes versions, it changes so much…
Re: Senior Oracle DBA now Learning Informix by Request
Its a troll bait argument. The fact is that Oracle employees know that the statement is true. There is a very, very large Informix shop that runs with only a handfull of DBAs. They also know that IBMers and exIBMers (Myself Included) are not allowed to talk about their customer…
HPL 2kb unload 8KB load
Hello All, Wondering about something covered by the below snipit from this thread.. The noconversion job I was having trouble with seems to be working fine now after some tweaks to the HPL configuration re: shared memory etc. My question now is regarding the unload of 2K page …
Re: Crazy HPL Error - 2KB unload Load into 8KB.....
Hello All, Wondering about something covered by the below snipit from this thread.. The noconversion job I was having trouble with seems to be working fine now after some tweaks to the HPL configuration re: shared memory etc. My question now is regarding the unload of 2K page …
RE: Senior Oracle DBA now Learning Informix by Request
Next question. How long has RMAN been around and trustworthy? I can't quote how long onbar has been around (somebody out here probably knows), but I know we trusted onbar much sooner than our oracle dba trusted rman. Is RMAN advised to be housed in a separate oracle instance? …
Re: Senior Oracle DBA now Learning Informix by Request
This sounds like Wal-mart. Which is probably the largest Informix shop. jp Darren_Jacobs@car max.com Sent by: To informix-list-bou DA Morgan <damorgan@psoug.org> …
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166054192.895791@bubbleator.drizzle.com... >> Obnoxio The Clown wrote: >> >>> Funny how most of the dinosaur Informix DBA's are still managing their >>> IDS >>> databases the way they managed version 7.…
RE: Disable Constraint
To your question.... Are you loading a table? Updating/Inserting/Deleting from a table? Are you asking if modifying the sysobjstate table, will Infmx DYNAMICALLY disable the constraint 'after' a transaction has already begun? or ... Are you asking if that is ALL you need to d…
RE: ISQL install problem
Sorry to jump in at the last moment, but have you looked at the machine notes in the directory you installed isql in? If you downloaded it from PPA, you need to remember that over the last year or so the database tool items on that site have been consistently mislabeled. Look a…
Re: A way to get autogenerated keys
I copied this FTFM (From The Fine Manual): If you execute the getSerial() or getSerial8() method after a CREATE TABLE statement, the method returns 1 by default (assuming the new table includes a SERIAL or SERIAL8 column). If the table does not contain a SERIAL or SERIAL8 column…
Disable Constraint
What does Informix do when you disable a constraint? I'm running one on a 188M row table and it is doing a lot of reads (over 1M so far) I though all it had to do was change the state column in sysobjstate to 'D' Regards Colin There are 10 types of people in the world, those …
Thread Migration Statistics
Hi, onstat -g sch gives two informations: VP Scheduler Stats and Thread Migration Statistics. I'm looking for any information about Thread Migration Statistics. Does anyone know what is it about? What does it mean: 'steal-at steal-sc idlvp-at idlvp-sc inl-polls Q-ln'? I couldn't…
Re: For those working on the SUN platform
Can you forward that document to me? Regards, Mukil -- Mukilan ------------------------------------------------------------------------ Mukilan's Profile: http://unixadmintalk.com/591 View this thread: http://unixadmintalk.com/showthread.php?t=200395…
RE: TBTAPE Level 0 Multiple Tape Archive
Hi, I am not sure about 5.x versions, but we once used the approach to backup the image in filesystem on a different machine (internally does a rcmd <machine> dd if= ... of= ). This worked with files > 2GB (but only on machines <> localhost), but on a different platform (should …
Re: ISQL install problem
Hi Clive, I do have an unlimited shared memory connection, but am not sure of any others - is there a way that I can check this? Thanks Andy…
Re: ISQL install problem
Hi, Thanks for your reply - I'm not exactly sure what you mean or how I would check this. I certainly haven't intentionally done this. Thanks Andy…
Re: ISQL install problem
is it the "query language" isql that is not working or is it a form or a report? if it is a form or a report is the form or report "hard coding" a different server name in the database statement? is there a Connections option in ISQL that lists the various servers listed in your…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
DA Morgan said: > Obnoxio The Clown wrote: >> DA Morgan said: >>>> DA Morgan said: >>>>> If you have some aethetically pleasing code that will >>>>> run more efficiently on the same hardware I'd sincerely like to see >>>>> it. >>> I'm not interested in your religion or your elega…
Re: ISQL install problem
On 13/12/06, Clive Eisen <clive@serendipita.com> wrote: > andrew.burridge@gmail.com wrote: > > Hi Clive, thanks for your reply, > > > > I installed to a different directory, but I still can't get it to work! > > > > > > Are the any other config files used for stipulating such thi…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
Ian Michael Gumby wrote: > It looks like you have to pass by reference, yet if your first parameter > is CHAR(4), you have to create a data type char4 as CHAR(4) and then in > your procedure input the first variable as a type char4. I can't even grok this statement - can you cl…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
Ian Michael Gumby wrote: > > > If you look at any other language of same era, you have better defined > looping constructs. (While(), Do(while()), For(), etc ... > PL/SQL has all these looping constructs, and more, and has had them since the first release. It also has encapsulat…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
Art S. Kagel wrote: > Mark Townsend wrote: >> This is an old chestnut. It's never been proven that Informix is >> easier to own or operate than Oracle. > > PLEASE STOP! Laughing that hard causes me pain! > > Do you know of ANY Oracle sites that are running 2000, 4000, 8000, or …
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
DA Morgan wrote: >Yeah ... statements containing INSERT, UPDATE, and DELETE. So what about MERGE? what about more than one statement? > One more thing Serge ... if you have non-clunky code that will equal > its performance I'd really like to see it. Daniel, you are missing the …
Re: Senior Oracle DBA now Learning Informix by Request
Obnoxio The Clown wrote: > Funny how most of the dinosaur Informix DBA's are still managing their IDS > databases the way they managed version 7. And the market penetration of Informix and Oracle 7 are roughly similar. Coincidence? <g> -- Daniel A. Morgan University of Washing…
Re: Senior Oracle DBA now Learning
Ian Michael Gumby wrote: > > > >> Mark Townsend said: >> > >> > PL/SQL is actually pretty sublime as a language. >> >> Is that compared to Strine? >> >> -- >> Bye now, >> Obnoxio >> > Actually its pretty primative, considering that C had been around since > '72 and PL/SQL could h…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
Mark Townsend wrote: > elanleblanc@yahoo.com wrote: > >> Oracle DBA's work much harder than Informix DBA's, at least on database >> administration duties. You deserve the extra pay. >> >> Informix DBA's spend more time joshing on CDI and developing software >> and heaven knows w…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
> >DA Morgan said: > > If you have some aethetically pleasing code that will > > run more efficiently on the same hardware I'd sincerely like to see it. > >10 PRINT "Oracle sucks" >20 GOTO 10 > >-- LOL... Ok, as much fun as it is to play on this... My current client is running…
Re: Senior Oracle DBA now Learning InformixbyRequestofCompany
> >Tambi Dude said: > > > > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > > news:mailman.538.1165996223.29126.informix-list@iiug.org... > >> > >> Mark Townsend said: > >> > >>> but here are Oracle we are all > >>> very proud of PL/SQL. It's a great language. > …
Re: Senior Oracle DBA now Learning
>Mark Townsend said: > > > > PL/SQL is actually pretty sublime as a language. > >Is that compared to Strine? > >-- >Bye now, >Obnoxio > Actually its pretty primative, considering that C had been around since '72 and PL/SQL could have gained a great deal from the basic structures.…
Re: Crazy HPL Error....
Neil Truby wrote: > "Tam O'Shanter" <tam@oshanter.com> wrote in message > news:PQCfh.426276$tl2.81137@fe10.news.easynews.com... > >>Greetings, >> >>Muddled my way through unloading a large IFX 10UC4 database and am trying >>to work through the load process. >> >>HPL is really ama…
Port / Service of SQL editor
Hi all, Which port/services uses the sql Editor ? The firewall is restricting my conections... Thank's to all. Omar. __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam �gratis! Reg�strate ya - …
Port / Service of SQL editor
Hi all, Which port/services uses the sql Editor ? The firewall is restricting my conections... Thank's to all. Omar. __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.e…
NEED EXACT STATEMENTS for DB2 ONLINE BACUP.
I checked the udb Db , logretain =RECOVERY and USEREXIT=no , i need to do online backup , please help…