RSS Feed: IDS Forum: IDS

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine

NCHAR en HDR
Posted by: vestrada@comercio.com.pe (VLADIMIR ESTRADA) - Fri, 29 Aug 2008 21:30:09 EDT
Buenas noches,
En un esquema HDR, en el servidor Primario tengo una tabla con 4 campos de
tipo nchar(500), en un dia de semana (el de mayor carga) se insertan decenas
de miles de registros a dicha tabla, pero ésta se corrompe en el servidor
secundario. El tiempo de replicación es de cinco segundos. No hay índices
sobre los campos NCHAR. ¿A qué se puede deber la corrupción de la tabla? ¿A
los campos NCHAR? ¿�ndices? o otros?

Doy un mayor detalle de la plataforma:
Sistema Operativo: Sun Solaris
Informix: IDS v10.00 FC8

Tabla:
create table "informix".avisos
(

cod_agencia varchar(10) not null ,

cod_sede varchar(10) not null ,

cod_aviso varchar(10) not null ,

tipo_aviso char(3),

cod_cliente varchar(10),

cod_cliente_fact varchar(10),

id_medio integer,

id_publicacion integer,

id_edicion integer,

id_seccion integer,

id_subseccion integer,

id_ubicacion integer,

id_tarifa integer,

id_medida integer,

cod_medio varchar(10),

dsc_medio varchar(50),

cod_publicacion varchar(10),

dsc_publicacion varchar(50),

cod_edicion varchar(10),

dsc_edicion varchar(50),

cod_seccion varchar(10),

dsc_seccion varchar(50),

cod_subseccion varchar(10),

dsc_subseccion varchar(50),

cod_ubicacion varchar(10),

dsc_ubicacion varchar(50),

cod_tarifa varchar(10),

dsc_tarifa varchar(50),

dsc_medida varchar(50),

cod_color varchar(10),

dsc_color varchar(50),

cod_material varchar(10),

dsc_material varchar(50),

forma_pago char(1),

cod_moneda char(1),

dsc_tituloaviso nchar(500), -- 1ER CAMPO NCHAR

dsc_textoaviso nchar(500), -- 2DO CAMPO NCHAR

fechas_publicacion nchar(500), -- 3ER CAMPO NCHAR

importe_bruto decimal(15,2),

importe_recargo decimal(15,2),

importe_descuento decimal(15,2),

importe_igv decimal(15,2),

importe_neto decimal(15,2),

importe_cliente decimal(15,2),

id_marca integer,

sec_marca smallint,

id_modelo integer,

sec_modelo smallint,

dsc_color_auto varchar(50),

sec_color_auto smallint,

anho_fabricconst varchar(4),

sec_anho_fabri smallint,

cod_moneda_precio char(1),

importe_precio decimal(15,2),

sec_importe_precio smallint,

id_transmision integer,

sec_transmision smallint,

cnt_kilometraje decimal(11),

sec_kilometraje smallint,

id_traccion integer,

sec_traccion smallint,

id_timon integer,

sec_timon smallint,

id_puertas integer,

sec_puertas smallint,

id_cilindro integer,

sec_cilindro integer,

id_combustible integer,

sec_combustible smallint,

nro_telefono1 varchar(20),

nro_telefono2 varchar(20),

nro_telefono3 varchar(20),

dsc_email varchar(50),

dsc_direccontacto varchar(100),

dsc_direccion varchar(100),

sec_direccion smallint,

dsc_textoweb nchar(500), -- 4TO CAMPO NCHAR

nro_palabras integer,

dsc_servicio varchar(100),

sec_servicio smallint,

dsc_disponibilidad varchar(50),

sec_disponibilidad smallint,

cod_departamento varchar(10),

sec_departamento smallint,

cod_distrito varchar(10),

sec_distrito smallint,

cod_urbanizacion varchar(10),

sec_urbanizacion smallint,

area_total decimal(15),

sec_area_total smallint,

area_construida decimal(15),

sec_area_const smallint,

id_habitacion integer,

sec_habitacion smallint,

id_banhos integer,

sec_banhos smallint,

id_pisos integer,

sec_pisos smallint,

est_aviso char(1),

est_anulacion char(1),

fch_registro datetime year to second,

fch_recepcion datetime year to second,

fch_anulacion datetime year to second,

fch_envio datetime year to second,

fch_actualizacion datetime year to second,

med_horizontal decimal(6,2),

med_vertical decimal(6,2),

nro_dias smallint,

cod_contrato varchar(10),

nombre_vineta varchar(25),

dsc_fotovineta varchar(50),

est_fotovineta char(1),

dsc_fotoweb varchar(50),

est_fotoweb char(1),

nombre_imp varchar(50),

est_downimp char(1),

nro_doccli varchar(20),

dsc_dircli varchar(100),

est_impresion char(1),

est_emitido char(1),

cod_ejecutivo_age varchar(10),

cod_ejecutivo_ec varchar(10),

est_estructurado char(1),

aviso_asociado varchar(10),

est_cierre char(1)

default 'N',

id_promocion integer,

cod_agencia_emisor varchar(10),

cod_sede_emisor varchar(10),

cod_canal varchar(10),

cod_empresa varchar(10),

ad_number char(10),

est_orden char(1),

est_recmaterial char(1)

default 'N',

cod_user_anula varchar(10),

obs_anulacion varchar(100),

cod_direct_fact varchar(10),

est_publicado char(1)

default 'S',

cod_agenciactr varchar(10)

default null,

cod_motivoemi varchar(3)

default null,

cod_subforpgo varchar(2)

default null,

cod_contratocred varchar(10)

default null,

cod_diasplazo varchar(3)

default null,

est_downxml char(1)

default 'N' not null ,

est_pubxml char(1)

default 'N' not null ,

primary key (cod_agencia,cod_sede,cod_aviso) constraint "informix".pk_agcsdavs
) extent size 9000000 next size 1200000 lock mode row;
revoke all on "informix".avisos from "public" as "informix";

create index "informix".idx_fecregav on "informix".avisos (fch_registro)

using btree in otrosdbs1 ;
create index "informix".idx_nroadp on "informix".avisos (ad_number)

using btree in otrosdbs1 ;

Los extents son los correctos, el tipo de bloqueo debe ser ROW. Los parámetros
de S.O y BD son =s en ambos servidores (Primario y Secundariio). Por favor si
alguien sabe el problema o una pista, se agradece.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13259]

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

Re: Where records the fragment table's partnum ?!
Posted by: jmmagie@yahoo.com (MIKE MAGIE) - Fri, 29 Aug 2008 13:51:26 EDT
True dat Art -

In addition if you look at the output from oncheck -pt the part that says...

Partition partnum 11534338
Partition lockid 10485815

....Will tell you if the table is fragged or not. The Partition partnum entry
corresponds to the first fragment's partnumber, the Partition lockid is the
partnumber for the additional fragment(s) - there will be an entry for each
frag.

MM




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13258]

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

Re: LVARCHAR vs TEXT
Posted by: miller3@us.ibm.com (John Miller iii) - Fri, 29 Aug 2008 11:58:01 EDT
Here is a few things off the top of my head.

LVARCHAR Partition Blob
Max Size 32K - rowsize 2GB
In row overhead 2 bytes 56 bytes
cast to char Yes No by default
Fills partial pages Yes Yes

Hope this helps,

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

=

"FRANK" =

<yunyaoqu@gmail.c =

om> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

LVARCHAR vs TEXT [13256] =

08/29/2008 08:13 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Folks,

Is there a comparison between TEXT and LVARCHAR, e.g., usage, performan=
ce,
disk allocation, benefits, SQL/XML,....?
Any suggestions/conclusions?

Thanks a lot,
Frank

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***=
* * * * * * * *



=




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13257]

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

LVARCHAR vs TEXT
Posted by: yunyaoqu@gmail.com (FRANK) - Fri, 29 Aug 2008 11:13:26 EDT
Folks,

Is there a comparison between TEXT and LVARCHAR, e.g., usage, performance,
disk allocation, benefits, SQL/XML,....?
Any suggestions/conclusions?

Thanks a lot,
Frank




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13256]

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

About 0913
Posted by: qadirspn@rediffmail.com (ABDUL QADIR) - Fri, 29 Aug 2008 11:11:08 EDT
I m preparing for Informix-4GL developer certification(0913), any advise help
me for clarifying the certification. I have a very limited text.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13255]

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

Re: Re sync replicate tables
Posted by: smiley73@googlemail.com (Keith Simmons) - Fri, 29 Aug 2008 03:47:26 EDT
2008/8/29 MURALIKRISHNA NANDURI <mk_nanduri@hotmail.com>:
> Hello every one ,
>
> Recently we migrated subset of data from one of our production servers to a
> new database server. After the migration we did not start the replication
for
> about a week. During the non replication time ( about a week) they were
> updates to our old server which are not propagated the new one . I believe
> there are about 100 tables replicated ( We do not replicate the entire
> database).Now I want to extract the missing data from the old server to the
> new server. These two servers are a part of 3 other servers in the
> replication. The 100 tables in question could have been updated in any one
of
> those 3 servers
> All our engines are on HP-ux Version 11 and IDS 10 fc4
>
> My goal is to resync all those replication table in all the 5 engines.
>
> I am just looking for any body who have any tools or if you know off any
> company has a product which can accomplish this task .
>
> I highly appreciate any info
> Thanks
> Murali nanduri
>
>
>

>
>
>

Murali

You may find the quickest, simplest and safest way is to migrate the
data again, when the databases are quiet, and then immediately start
replication.
You could script to detect changes and apply them, or investigate cdr
sync, but these could take some time. If you can get a quiet period
migrating the data would be best.

Keith




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13254]

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

Re: Where records the fragment table's partnum ?!
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 28 Aug 2008 23:10:41 EDT
Besides the system catalog tables, systables and sysfragments, all of the
fragments of a table have the same lockid which is actually the partnum of
the first partition defined for the table or index. Look in
sysmaster:systabnames and sysmaster:sysptnhdr.

Art

On Thu, Aug 28, 2008 at 9:32 PM, MARS CHEN <mars@jsun.com> wrote:

> Thank you Mike !!!
>
> >In dbspace #2 you have a partition page whose logical address is 0x2002f4
> >In dbspace #3 you have a partition page whose logical address is 0x300002
> >In dbspace #4 you have a partition page whose logical address is 0x400002
>
> >oncheck -pp 0x200001 0x2f4
> >oncheck -pp 0x300001 0x2
> >oncheck -pp 0x400001 0x2
>
> and you are right !!... each oncheck -pp would showes each partnum
> in the first 4 bytes of slot 1 ....
>
> What I am curious to know is that ... Why IDS knows nologtest:stkhis
> is a fragment table ?!... there should be some flag describe it ~~
>
> in my case , I create fragment table stkhis in dbspace1 and dbspace2 ,
> and then create index in dbspace3 , so I'll have 3 partition pages
> for table nologtest:stkhis , that is what I know , What I don't know is
> where record that this table is fragmented ?! and create index in another
> dbspace , there should be a structure describe this ~~~
>
> thanks for your kind response , Mike ..It is nice of you ~~
>
>
>
>

>
>
>

--
Art S. Kagel
Oninit (www.oninit.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, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13253]

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

Re: Where records the fragment table's partnum ?!
Posted by: mars@jsun.com (MARS CHEN) - Thu, 28 Aug 2008 23:01:16 EDT
Thank you , John ...

You help a lot , I got it ...




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13252]

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

Re: Re sync replicate tables
Posted by: mpruet@us.ibm.com (Madison Pruet) - Thu, 28 Aug 2008 22:34:43 EDT
IDS10xC4 has the "cdr sync" command. That might be the best solution.

-------------------------------------
Madison Pruet, STSM
IDS Replication Architect

=

"MURALIKRISHNA =

NANDURI" =

<mk_nanduri@hotma =
To

il.com> ids@iiug.org =

Sent by: =
cc

ids-bounces@iiug. =

org Subj=
ect

Re sync replicate tables [13248=
]

=

08/28/2008 07:55 =

PM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hello every one ,

Recently we migrated subset of data from one of our production servers =
to a

new database server. After the migration we did not start the replicati=
on
for
about a week. During the non replication time ( about a week) they were=

updates to our old server which are not propagated the new one . I beli=
eve
there are about 100 tables replicated ( We do not replicate the entire
database).Now I want to extract the missing data from the old server to=
the

new server. These two servers are a part of 3 other servers in the
replication. The 100 tables in question could have been updated in any =
one
of
those 3 servers
All our engines are on HP-ux Version 11 and IDS 10 fc4

My goal is to resync all those replication table in all the 5 engines.

I am just looking for any body who have any tools or if you know off an=
y
company has a product which can accomplish this task .

I highly appreciate any info
Thanks
Murali nanduri

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***=
* * * * * * * *



=




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13251]

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

Re: Where records the fragment table's partnum ?!
Posted by: miller3@us.ibm.com (John Miller iii) - Thu, 28 Aug 2008 22:05:00 EDT
For fragmented tables the partnum of systables entry is 0 and the
information
about each fragment is stored in sysfragments.

At the disk level the parent partition number will be stored in pn_lock=
id
field in the
partition structure. look at oncheck -pt dbs:table

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

=

"MARS CHEN" =

<mars@jsun.com> =

Sent by: =
To

ids-bounces@iiug. ids@iiug.org =

org =
cc

=

Subj=
ect

08/28/2008 06:32 Re: Where records the fragment =

PM table's partnum ?! [13249] =

=

=

Please respond to =

ids@iiug.org =

=

=

Thank you Mike !!!

>In dbspace #2 you have a partition page whose logical address is 0x200=
2f4
>In dbspace #3 you have a partition page whose logical address is 0x300=
002
>In dbspace #4 you have a partition page whose logical address is 0x400=
002

>oncheck -pp 0x200001 0x2f4
>oncheck -pp 0x300001 0x2
>oncheck -pp 0x400001 0x2

and you are right !!... each oncheck -pp would showes each partnum
in the first 4 bytes of slot 1 ....

What I am curious to know is that ... Why IDS knows nologtest:stkhis
is a fragment table ?!... there should be some flag describe it ~~

in my case , I create fragment table stkhis in dbspace1 and dbspace2 ,
and then create index in dbspace3 , so I'll have 3 partition pages
for table nologtest:stkhis , that is what I know , What I don't know is=

where record that this table is fragmented ?! and create index in anoth=
er
dbspace , there should be a structure describe this ~~~

thanks for your kind response , Mike ..It is nice of you ~~

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***=
* * * * * * * *



=




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13250]

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

Re: Where records the fragment table's partnum ?!
Posted by: mars@jsun.com (MARS CHEN) - Thu, 28 Aug 2008 21:32:49 EDT
Thank you Mike !!!

>In dbspace #2 you have a partition page whose logical address is 0x2002f4
>In dbspace #3 you have a partition page whose logical address is 0x300002
>In dbspace #4 you have a partition page whose logical address is 0x400002

>oncheck -pp 0x200001 0x2f4
>oncheck -pp 0x300001 0x2
>oncheck -pp 0x400001 0x2

and you are right !!... each oncheck -pp would showes each partnum
in the first 4 bytes of slot 1 ....

What I am curious to know is that ... Why IDS knows nologtest:stkhis
is a fragment table ?!... there should be some flag describe it ~~

in my case , I create fragment table stkhis in dbspace1 and dbspace2 ,
and then create index in dbspace3 , so I'll have 3 partition pages
for table nologtest:stkhis , that is what I know , What I don't know is
where record that this table is fragmented ?! and create index in another
dbspace , there should be a structure describe this ~~~

thanks for your kind response , Mike ..It is nice of you ~~




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13249]

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

Re sync replicate tables
Posted by: mk_nanduri@hotmail.com (MURALIKRISHNA NANDURI) - Thu, 28 Aug 2008 20:55:06 EDT
Hello every one ,

Recently we migrated subset of data from one of our production servers to a
new database server. After the migration we did not start the replication for
about a week. During the non replication time ( about a week) they were
updates to our old server which are not propagated the new one . I believe
there are about 100 tables replicated ( We do not replicate the entire
database).Now I want to extract the missing data from the old server to the
new server. These two servers are a part of 3 other servers in the
replication. The 100 tables in question could have been updated in any one of
those 3 servers
All our engines are on HP-ux Version 11 and IDS 10 fc4

My goal is to resync all those replication table in all the 5 engines.

I am just looking for any body who have any tools or if you know off any
company has a product which can accomplish this task .

I highly appreciate any info
Thanks
Murali nanduri




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13248]

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

RE: Install Cheetah 2 on Ubuntu 8...
Posted by: jgp@jgp.net (Jean Georges Perrin) - Thu, 28 Aug 2008 11:32:33 EDT
No, I have not done it as the user Informix, I did it as jgp and start
installation as root...

I will try that...

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Obnoxio The Clown
> Sent: Thursday, August 28, 2008 16:34
> To: ids@iiug.org
> Subject: Re: Install Cheetah 2 on Ubuntu 8... [13245]
>
> Jean Georges Perrin wrote:
> > I did uncompress the tas, if I go there and type ls -l, I get:
> >
> > total 5324
> > -rw-r--r-- 1 jgp jgp 33102 2008-04-25 02:15 bundle.ini
> > drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 CSDK
> > drwxr-xr-x 5 jgp jgp 4096 2008-04-25 02:28 DBLD
> > drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 ICONNECT
> > -rwxr-xr-x 1 jgp jgp 74752 2008-04-25 02:15 ids_install
> > drwxr-xr-x 2 jgp jgp 4096 2008-04-25 02:15 images
> > drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:28 JDBC
> > drwxr-xr-x 15 jgp jgp 4096 2008-04-25 23:49 jre_license
> > -rw-r--r-- 1 jgp jgp 4635 2008-04-25 02:15 README.html
> > drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 SERVER
> > -rwxr-xr-x 1 jgp jgp 5279879 2008-04-25 02:15 suite.jar
> >
>
> Doesn't look like you did it as user "informix", then, does it?
>
> --
> Cheers,
> Obnoxio the Clown
>
> http://obotheclown.blogspot.com
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***
> * * * * * * * *
>




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13247]

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

RE: Business Objects and Informix 11
Posted by: patmcd@intraware.com (Patrick McDonough) - Thu, 28 Aug 2008 11:12:39 EDT
Informix 11 is not listed on BOBJ's list of "Supported Platforms" as a
data source either. Should 11 work just like 10? Yes it should.
BOBJ's support does, however like to use the fact that you have an
unsupported platform as a reason to avoid support. I don't think BOBJ
will ever support Informix as a repository again. They went from native
connectivity with repository and datasource (<2.X) to ODBC for both repo
and data (E6.x) to ODBC for data source only (XI.X). The trend is
obvious.

I've installed XI 3 using their default install - linux, mysql as the
repository - connecting to ANY version of Informix ( tried 11, 10, 9 and
even fired up an old 7.3 instance ) and hasn't worked. The tech case is
now over 2 1/2 months old. I feel the BOBJ(SAP)/Informix love.

Patrick

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alexey Sonkin
Sent: Wednesday, August 27, 2008 3:55 PM
To: ids@iiug.org
Subject: RE: Business Objects and Informix 11 [13233]

Actually, BO is not certified with IDS as metadata repository, but
perfectly works with IDS 11 as a data source.
I don't see any problem with this: repository is a tiny database, and
one can use something like MySQL or (free) DB2 Express-C to store BO
metadata

-Alexey

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
SCOTT ROBERTS
Sent: Wednesday, August 27, 2008 6:11 PM
To: ids@iiug.org
Subject: Business Objects and Informix 11 [13230]

We are in process of upgrading several servers to Informix 11. We hit a
wall
when we found out Business Objects has not certified Informix 11. We
have been
working up the chain at both Business Objects and IBM Informix to push
Business Objects to support Informix 11. We seem to be making some
progress.
If there is any one else out there interested in getting Business
Objects to
certify Informix 11 now is the time to jump on the bandwagon. Ask
Business
Objects to support Informix 11 and tell your IBM rep you have need of it

as
well.

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

* * * * ***


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





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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13246]

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

Re: Install Cheetah 2 on Ubuntu 8...
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Thu, 28 Aug 2008 10:33:35 EDT
Jean Georges Perrin wrote:
> I did uncompress the tas, if I go there and type ls -l, I get:
>
> total 5324
> -rw-r--r-- 1 jgp jgp 33102 2008-04-25 02:15 bundle.ini
> drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 CSDK
> drwxr-xr-x 5 jgp jgp 4096 2008-04-25 02:28 DBLD
> drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 ICONNECT
> -rwxr-xr-x 1 jgp jgp 74752 2008-04-25 02:15 ids_install
> drwxr-xr-x 2 jgp jgp 4096 2008-04-25 02:15 images
> drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:28 JDBC
> drwxr-xr-x 15 jgp jgp 4096 2008-04-25 23:49 jre_license
> -rw-r--r-- 1 jgp jgp 4635 2008-04-25 02:15 README.html
> drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 SERVER
> -rwxr-xr-x 1 jgp jgp 5279879 2008-04-25 02:15 suite.jar
>

Doesn't look like you did it as user "informix", then, does it?

--
Cheers,
Obnoxio the Clown

http://obotheclown.blogspot.com




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13245]

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

RE: Install Cheetah 2 on Ubuntu 8...
Posted by: jgp@jgp.net (Jean Georges Perrin) - Thu, 28 Aug 2008 10:30:02 EDT
I did uncompress the tas, if I go there and type ls -l, I get:

total 5324
-rw-r--r-- 1 jgp jgp 33102 2008-04-25 02:15 bundle.ini
drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 CSDK
drwxr-xr-x 5 jgp jgp 4096 2008-04-25 02:28 DBLD
drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 ICONNECT
-rwxr-xr-x 1 jgp jgp 74752 2008-04-25 02:15 ids_install
drwxr-xr-x 2 jgp jgp 4096 2008-04-25 02:15 images
drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:28 JDBC
drwxr-xr-x 15 jgp jgp 4096 2008-04-25 23:49 jre_license
-rw-r--r-- 1 jgp jgp 4635 2008-04-25 02:15 README.html
drwxr-xr-x 3 jgp jgp 4096 2008-04-25 02:27 SERVER
-rwxr-xr-x 1 jgp jgp 5279879 2008-04-25 02:15 suite.jar

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Fernando Nunes
> Sent: Thursday, August 28, 2008 16:19
> To: ids@iiug.org
> Subject: Re: Install Cheetah 2 on Ubuntu 8... [13243]
>
> Never saw that error...
> But make sure you uncompress the tar file (if that's what you're using)
> with
> user Informix
> Regards.
>
> On Thu, Aug 28, 2008 at 2:39 PM, Jean Georges Perrin <jgp@jgp.net>
> wrote:
>
> > Hi,
> >
> > I am trying to install Cheetah 2 on Ubuntu 8, both are 64 bits.
> >
> > I had a few problems with dependencies, and I think I solve them all
> by
> > updating the system. Now I get:
> > The wizard cannot continue because of the following error: could not
> load
> > wizard specified in /wizard.inf (104)
> >
> > When I run:
> > sudo ./ids_install -console
> > or
> > sudo ./ids_install
> >
> > any hint?
> >
> > (Ok - I know Ubuntu 8 is not supported, I am building a development
> virtual
> > machine using the IIUG developer edition).
> >
> > Thanks!
> >
> > jgp
> >
> >
> >
> >
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***
> * * * * * * * *
> >
> >
> >
>
> --
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***
> * * * * * * * *
>




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13244]

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

Re: Install Cheetah 2 on Ubuntu 8...
Posted by: domusonline@gmail.com (Fernando Nunes) - Thu, 28 Aug 2008 10:19:18 EDT
Never saw that error...
But make sure you uncompress the tar file (if that's what you're using) with
user Informix
Regards.

On Thu, Aug 28, 2008 at 2:39 PM, Jean Georges Perrin <jgp@jgp.net> wrote:

> Hi,
>
> I am trying to install Cheetah 2 on Ubuntu 8, both are 64 bits.
>
> I had a few problems with dependencies, and I think I solve them all by
> updating the system. Now I get:
> The wizard cannot continue because of the following error: could not load
> wizard specified in /wizard.inf (104)
>
> When I run:
> sudo ./ids_install -console
> or
> sudo ./ids_install
>
> any hint?
>
> (Ok - I know Ubuntu 8 is not supported, I am building a development virtual
> machine using the IIUG developer edition).
>
> Thanks!
>
> jgp
>
>
>
>

>
>
>

--
--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13243]

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

Re: Work Group Server ON APPLE OSX 10.5 ????--....
Posted by: (BILL MARSHA....) - Thu, 28 Aug 2008 10:01:47 EDT
Is ISQL and I$GL also available for use on Apple OS X 10.5

In particular I am trying to evaluate using and Apple or a Linux machine to
support a production WGS database instance.
------WebKitFormBoundaryfDMvVsoNIO7Yj+Do




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13242]

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

Install Cheetah 2 on Ubuntu 8...
Posted by: jgp@jgp.net (Jean Georges Perrin) - Thu, 28 Aug 2008 09:39:25 EDT
Hi,

I am trying to install Cheetah 2 on Ubuntu 8, both are 64 bits.

I had a few problems with dependencies, and I think I solve them all by
updating the system. Now I get:
The wizard cannot continue because of the following error: could not load
wizard specified in /wizard.inf (104)

When I run:
sudo ./ids_install -console
or
sudo ./ids_install

any hint?

(Ok - I know Ubuntu 8 is not supported, I am building a development virtual
machine using the IIUG developer edition).

Thanks!

jgp




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13241]

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

Re: Where records the fragment table's partnum ?!
Posted by: jmmagie@yahoo.com (MIKE MAGIE) - Thu, 28 Aug 2008 09:24:35 EDT
When you create a fragmented table you will have a partition page (or
tablespace tablespace page) for each fragment, in the dbspace where that
fragment resides. In your case:

Table fragment in DBspace dbspace1
Partition partnum 2097908(0x2002F4)

Table fragment in DBspace dbspace2
Partition partnum 3145730(0x300002)

Index stkhis_ix fragment in DBspace dbspace3
Partition partnum 4194306(0x400002)

In dbspace #2 you have a partition page whose logical address is 0x2002f4
In dbspace #3 you have a partition page whose logical address is 0x300002
In dbspace #4 you have a partition page whose logical address is 0x400002

The logical address is made up of dbspace # and logical page #. So in the
first example the 0x2 means dbspace 2, and the 0x002f4 is the logical page #.
If you wanted to look at these partition pages you would use:

oncheck -pp 0x200001 0x2f4
oncheck -pp 0x300001 0x2
oncheck -pp 0x400001 0x2

The first arg above is the address of the main tablespace tablespace page for
each dbspace, the tblspace tblspace tracks all tables (and fragments) in the
dbspace - every dbspace has one and they are all the logical page 1 in the
dbspace, (logical page 0 is a bitmap page). Given any table's partnumber
(partition page number, tablespace tablespace id, etc) you can locate its
actual partition page.

Remember that each tablespace tablespace tracks tables. Look at the first 4
bytes of slot 1 to verify that you have the correct partition page.

Sorry if I confused - I wrote this fast.

Mike




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [13240]

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