Fw: table estimate_compression error

Sent a note out last week about this ... Aix 5.3, IDS 11.50.fc4 Trying to estimate the compression of the below table ... and get the error in the online log ... points to the table being in an index partition... I'm confused though, the table is the only object in the particular dbspace ... Any ideas? Peter Logan Senior Database Administrator Phone: 616/878-8309 ----- Forwarded by Peter Logan/Corporate/Spartan on 07/10/2009 03:08 PM ----- From: Informix PS/PM sp20/DEV <informix@spartan20.spartanstore.com> To: informix@spartan20.spartanstore.com Date: 07/10/2009 03:08 PM Subject: table estimate_compression error 14:56:58 SCHAPI Estimate Compression for hruat90:SHRUAT8.ps_s_gl_jrnl_lines started 14:56:58 Compression related operations not allowed on index partition hruat90:SHRUAT8.ps_s_gl_jrnl_lines 14:56:58 ERROR hruat90:SHRUAT8.ps_s_gl_jrnl_lines: rscCommand failed for partnum 23068674 14:56:58 Estimate Compression failed for hruat90:SHRUAT8.ps_s_gl_jrnl_lines, iserrno 0 14:56:58 SCHAPI ERROR: table estimate_compression hruat90:SHRUAT8.ps_s_gl_jrnl_lines failed create table "SHRUAT8".ps_s_gl_jrnl_lines ( run_id char(10) not null , emplid char(11) not null , paycheck_nbr decimal(15,0) not null , s_edt_code_pay char(8) not null , s_edt_code_map char(8) not null , business_unit_gl char(5) not null , gl_acct_num char(35) not null , s_gl_deptid char(4) not null , s_offset_gl_acct char(35) not null , s_offset_gl_deptid char(4) not null , type char(4) not null , affiliate char(5) not null , s_opco_bus_unit char(5) not null , s_opco_acct char(35) not null , s_opco_product char(6) not null , s_opco_gen_ind char(4) not null , product char(6) not null , s_offset_gl_prodct char(6) not null , pay_end_dt date, check_dt date, company char(3) not null , s_gen_ent_ind char(4) not null , s_gl_dr_cr_ind char(1) not null , amount decimal(18,3) not null , s_hours decimal(8,2) not null , s_opco_deptid char(10) not null ) in hruat_table_08 extent size 1048576 next size 524288 lock mode row; revoke all on "SHRUAT8".ps_s_gl_jrnl_lines from "public" as "SHRUAT8"; create unique index "SHRUAT8".ps_s_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines (run_id,emplid,paycheck_nbr,s_edt_code_pay,s_edt_code_map, business_unit_gl,gl_acct_num,s_gl_deptid,s_offset_gl_acct, s_offset_gl_deptid,type,affiliate,s_opco_bus_unit,s_opco_acct, s_opco_deptid,s_opco_product) using btree in hruat_index_08; create index "SHRUAT8".psas_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines (s_opco_bus_unit,s_opco_acct,s_opco_deptid,s_opco_product) using btree in hruat_index_08; create index "SHRUAT8".psbs_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines (run_id,emplid,paycheck_nbr,s_edt_code_pay) using btree in hruat_index_08;

You have an index named ps_s_gl_jrnl_lines on the ps_s_gl_jrnl_lines table and its confusing the compression function. Report the bug to IBM so they can fix it, then RENAME INDEX ps_s_gl_jrnl_lines to ps_s_gl_jrnl_lines_idx; and try again. Art 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. On Fri, Jul 10, 2009 at 3:11 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Sent a note out last week about this ... > > Aix 5.3, IDS 11.50.fc4 > > Trying to estimate the compression of the below table ... and get the > error in the online log ... points to the table being in an index > partition... I'm confused though, the table is the only object in the > particular dbspace ... > > Any ideas? > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 07/10/2009 03:08 PM > ----- > > From: > Informix PS/PM sp20/DEV <informix@spartan20.spartanstore.com> > To: > informix@spartan20.spartanstore.com > Date: > 07/10/2009 03:08 PM > Subject: > table estimate_compression error > > 14:56:58 SCHAPI Estimate Compression for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines started > 14:56:58 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_s_gl_jrnl_lines > 14:56:58 ERROR hruat90:SHRUAT8.ps_s_gl_jrnl_lines: rscCommand failed for > partnum 23068674 > 14:56:58 Estimate Compression failed for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines, iserrno 0 > 14:56:58 SCHAPI ERROR: table estimate_compression > hruat90:SHRUAT8.ps_s_gl_jrnl_lines failed > > create table "SHRUAT8".ps_s_gl_jrnl_lines > ( > > run_id char(10) not null , > > emplid char(11) not null , > > paycheck_nbr decimal(15,0) not null , > > s_edt_code_pay char(8) not null , > > s_edt_code_map char(8) not null , > > business_unit_gl char(5) not null , > > gl_acct_num char(35) not null , > > s_gl_deptid char(4) not null , > > s_offset_gl_acct char(35) not null , > > s_offset_gl_deptid char(4) not null , > > type char(4) not null , > > affiliate char(5) not null , > > s_opco_bus_unit char(5) not null , > > s_opco_acct char(35) not null , > > s_opco_product char(6) not null , > > s_opco_gen_ind char(4) not null , > > product char(6) not null , > > s_offset_gl_prodct char(6) not null , > > pay_end_dt date, > > check_dt date, > > company char(3) not null , > > s_gen_ent_ind char(4) not null , > > s_gl_dr_cr_ind char(1) not null , > > amount decimal(18,3) not null , > > s_hours decimal(8,2) not null , > > s_opco_deptid char(10) not null > ) in hruat_table_08 extent size 1048576 next size 524288 lock mode row; > > revoke all on "SHRUAT8".ps_s_gl_jrnl_lines from "public" as "SHRUAT8";> > create unique index "SHRUAT8".ps_s_gl_jrnl_lines on > "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay,s_edt_code_map, > > business_unit_gl,gl_acct_num,s_gl_deptid,s_offset_gl_acct, > > s_offset_gl_deptid,type,affiliate,s_opco_bus_unit,s_opco_acct, > > s_opco_deptid,s_opco_product) using btree in hruat_index_08; > > create index "SHRUAT8".psas_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (s_opco_bus_unit,s_opco_acct,s_opco_deptid,s_opco_product) > > using btree in hruat_index_08; > create index "SHRUAT8".psbs_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay) using btree > > in hruat_index_08; > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b52680d350046e5ecf59

Thanks ... I was wondering if that was the issue ... I'll give it a shot .... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 07/10/2009 03:17 PM Subject: Re: Fw: table estimate_compression error [16343] Sent by: ids-bounces@iiug.org You have an index named ps_s_gl_jrnl_lines on the ps_s_gl_jrnl_lines table and its confusing the compression function. Report the bug to IBM so they can fix it, then RENAME INDEX ps_s_gl_jrnl_lines to ps_s_gl_jrnl_lines_idx; and try again. Art 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. On Fri, Jul 10, 2009 at 3:11 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Sent a note out last week about this ... > > Aix 5.3, IDS 11.50.fc4 > > Trying to estimate the compression of the below table ... and get the > error in the online log ... points to the table being in an index > partition... I'm confused though, the table is the only object in the > particular dbspace ... > > Any ideas? > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 07/10/2009 03:08 PM > ----- > > From: > Informix PS/PM sp20/DEV <informix@spartan20.spartanstore.com> > To: > informix@spartan20.spartanstore.com > Date: > 07/10/2009 03:08 PM > Subject: > table estimate_compression error > > 14:56:58 SCHAPI Estimate Compression for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines started > 14:56:58 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_s_gl_jrnl_lines > 14:56:58 ERROR hruat90:SHRUAT8.ps_s_gl_jrnl_lines: rscCommand failed for > partnum 23068674 > 14:56:58 Estimate Compression failed for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines, iserrno 0 > 14:56:58 SCHAPI ERROR: table estimate_compression > hruat90:SHRUAT8.ps_s_gl_jrnl_lines failed > > create table "SHRUAT8".ps_s_gl_jrnl_lines > ( > > run_id char(10) not null , > > emplid char(11) not null , > > paycheck_nbr decimal(15,0) not null , > > s_edt_code_pay char(8) not null , > > s_edt_code_map char(8) not null , > > business_unit_gl char(5) not null , > > gl_acct_num char(35) not null , > > s_gl_deptid char(4) not null , > > s_offset_gl_acct char(35) not null , > > s_offset_gl_deptid char(4) not null , > > type char(4) not null , > > affiliate char(5) not null , > > s_opco_bus_unit char(5) not null , > > s_opco_acct char(35) not null , > > s_opco_product char(6) not null , > > s_opco_gen_ind char(4) not null , > > product char(6) not null , > > s_offset_gl_prodct char(6) not null , > > pay_end_dt date, > > check_dt date, > > company char(3) not null , > > s_gen_ent_ind char(4) not null , > > s_gl_dr_cr_ind char(1) not null , > > amount decimal(18,3) not null , > > s_hours decimal(8,2) not null , > > s_opco_deptid char(10) not null > ) in hruat_table_08 extent size 1048576 next size 524288 lock mode row; > > revoke all on "SHRUAT8".ps_s_gl_jrnl_lines from "public" as "SHRUAT8";> > create unique index "SHRUAT8".ps_s_gl_jrnl_lines on > "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay,s_edt_code_map, > > business_unit_gl,gl_acct_num,s_gl_deptid,s_offset_gl_acct, > > s_offset_gl_deptid,type,affiliate,s_opco_bus_unit,s_opco_acct, > > s_opco_deptid,s_opco_product) using btree in hruat_index_08; > > create index "SHRUAT8".psas_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (s_opco_bus_unit,s_opco_acct,s_opco_deptid,s_opco_product) > > using btree in hruat_index_08; > create index "SHRUAT8".psbs_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay) using btree > > in hruat_index_08; > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b52680d350046e5ecf59 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

That did it ... I'll report it to IBM. Thanks ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 07/10/2009 03:17 PM Subject: Re: Fw: table estimate_compression error [16343] Sent by: ids-bounces@iiug.org You have an index named ps_s_gl_jrnl_lines on the ps_s_gl_jrnl_lines table and its confusing the compression function. Report the bug to IBM so they can fix it, then RENAME INDEX ps_s_gl_jrnl_lines to ps_s_gl_jrnl_lines_idx; and try again. Art 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. On Fri, Jul 10, 2009 at 3:11 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Sent a note out last week about this ... > > Aix 5.3, IDS 11.50.fc4 > > Trying to estimate the compression of the below table ... and get the > error in the online log ... points to the table being in an index > partition... I'm confused though, the table is the only object in the > particular dbspace ... > > Any ideas? > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 07/10/2009 03:08 PM > ----- > > From: > Informix PS/PM sp20/DEV <informix@spartan20.spartanstore.com> > To: > informix@spartan20.spartanstore.com > Date: > 07/10/2009 03:08 PM > Subject: > table estimate_compression error > > 14:56:58 SCHAPI Estimate Compression for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines started > 14:56:58 Compression related operations not allowed on index partition > hruat90:SHRUAT8.ps_s_gl_jrnl_lines > 14:56:58 ERROR hruat90:SHRUAT8.ps_s_gl_jrnl_lines: rscCommand failed for > partnum 23068674 > 14:56:58 Estimate Compression failed for > hruat90:SHRUAT8.ps_s_gl_jrnl_lines, iserrno 0 > 14:56:58 SCHAPI ERROR: table estimate_compression > hruat90:SHRUAT8.ps_s_gl_jrnl_lines failed > > create table "SHRUAT8".ps_s_gl_jrnl_lines > ( > > run_id char(10) not null , > > emplid char(11) not null , > > paycheck_nbr decimal(15,0) not null , > > s_edt_code_pay char(8) not null , > > s_edt_code_map char(8) not null , > > business_unit_gl char(5) not null , > > gl_acct_num char(35) not null , > > s_gl_deptid char(4) not null , > > s_offset_gl_acct char(35) not null , > > s_offset_gl_deptid char(4) not null , > > type char(4) not null , > > affiliate char(5) not null , > > s_opco_bus_unit char(5) not null , > > s_opco_acct char(35) not null , > > s_opco_product char(6) not null , > > s_opco_gen_ind char(4) not null , > > product char(6) not null , > > s_offset_gl_prodct char(6) not null , > > pay_end_dt date, > > check_dt date, > > company char(3) not null , > > s_gen_ent_ind char(4) not null , > > s_gl_dr_cr_ind char(1) not null , > > amount decimal(18,3) not null , > > s_hours decimal(8,2) not null , > > s_opco_deptid char(10) not null > ) in hruat_table_08 extent size 1048576 next size 524288 lock mode row; > > revoke all on "SHRUAT8".ps_s_gl_jrnl_lines from "public" as "SHRUAT8";> > create unique index "SHRUAT8".ps_s_gl_jrnl_lines on > "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay,s_edt_code_map, > > business_unit_gl,gl_acct_num,s_gl_deptid,s_offset_gl_acct, > > s_offset_gl_deptid,type,affiliate,s_opco_bus_unit,s_opco_acct, > > s_opco_deptid,s_opco_product) using btree in hruat_index_08; > > create index "SHRUAT8".psas_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (s_opco_bus_unit,s_opco_acct,s_opco_deptid,s_opco_product) > > using btree in hruat_index_08; > create index "SHRUAT8".psbs_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > (run_id,emplid,paycheck_nbr,s_edt_code_pay) using btree > > in hruat_index_08; > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b52680d350046e5ecf59 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

This is reported as defect idsdb00187215. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 07/10/2009 12:16:38 PM: > [image removed] > > Re: Fw: table estimate_compression error [16343] > > Art Kagel > > to: > > ids > > 07/10/2009 12:20 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > You have an index named ps_s_gl_jrnl_lines on the ps_s_gl_jrnl_lines table > and its confusing the compression function. Report the bug to IBM so they > can fix it, then RENAME INDEX ps_s_gl_jrnl_lines to ps_s_gl_jrnl_lines_idx; > and try again. > > Art > > 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. > > On Fri, Jul 10, 2009 at 3:11 PM, Peter_Logan@spartanstores.com < > Peter_Logan@spartanstores.com> wrote: > > > Sent a note out last week about this ... > > > > Aix 5.3, IDS 11.50.fc4 > > > > Trying to estimate the compression of the below table ... and get the > > error in the online log ... points to the table being in an index > > partition... I'm confused though, the table is the only object in the > > particular dbspace ... > > > > Any ideas? > > > > Peter Logan > > Senior Database Administrator > > Phone: 616/878-8309 > > ----- Forwarded by Peter Logan/Corporate/Spartan on 07/10/2009 03:08 PM > > ----- > > > > From: > > Informix PS/PM sp20/DEV <informix@spartan20.spartanstore.com> > > To: > > informix@spartan20.spartanstore.com > > Date: > > 07/10/2009 03:08 PM > > Subject: > > table estimate_compression error > > > > 14:56:58 SCHAPI Estimate Compression for > > hruat90:SHRUAT8.ps_s_gl_jrnl_lines started > > 14:56:58 Compression related operations not allowed on index partition > > hruat90:SHRUAT8.ps_s_gl_jrnl_lines > > 14:56:58 ERROR hruat90:SHRUAT8.ps_s_gl_jrnl_lines: rscCommand failed for > > partnum 23068674 > > 14:56:58 Estimate Compression failed for > > hruat90:SHRUAT8.ps_s_gl_jrnl_lines, iserrno 0 > > 14:56:58 SCHAPI ERROR: table estimate_compression > > hruat90:SHRUAT8.ps_s_gl_jrnl_lines failed > > > > create table "SHRUAT8".ps_s_gl_jrnl_lines > > ( > > > > run_id char(10) not null , > > > > emplid char(11) not null , > > > > paycheck_nbr decimal(15,0) not null , > > > > s_edt_code_pay char(8) not null , > > > > s_edt_code_map char(8) not null , > > > > business_unit_gl char(5) not null , > > > > gl_acct_num char(35) not null , > > > > s_gl_deptid char(4) not null , > > > > s_offset_gl_acct char(35) not null , > > > > s_offset_gl_deptid char(4) not null , > > > > type char(4) not null , > > > > affiliate char(5) not null , > > > > s_opco_bus_unit char(5) not null , > > > > s_opco_acct char(35) not null , > > > > s_opco_product char(6) not null , > > > > s_opco_gen_ind char(4) not null , > > > > product char(6) not null , > > > > s_offset_gl_prodct char(6) not null , > > > > pay_end_dt date, > > > > check_dt date, > > > > company char(3) not null , > > > > s_gen_ent_ind char(4) not null , > > > > s_gl_dr_cr_ind char(1) not null , > > > > amount decimal(18,3) not null , > > > > s_hours decimal(8,2) not null , > > > > s_opco_deptid char(10) not null > > ) in hruat_table_08 extent size 1048576 next size 524288 lock mode row; > > > > revoke all on "SHRUAT8".ps_s_gl_jrnl_lines from "public" as "SHRUAT8";> > > > create unique index "SHRUAT8".ps_s_gl_jrnl_lines on > > "SHRUAT8".ps_s_gl_jrnl_lines > > > > (run_id,emplid,paycheck_nbr,s_edt_code_pay,s_edt_code_map, > > > > business_unit_gl,gl_acct_num,s_gl_deptid,s_offset_gl_acct, > > > > s_offset_gl_deptid,type,affiliate,s_opco_bus_unit,s_opco_acct, > > > > s_opco_deptid,s_opco_product) using btree in hruat_index_08; > > > > create index "SHRUAT8".psas_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > > > (s_opco_bus_unit,s_opco_acct,s_opco_deptid,s_opco_product) > > > > using btree in hruat_index_08; > > create index "SHRUAT8".psbs_gl_jrnl_lines on "SHRUAT8".ps_s_gl_jrnl_lines > > > > (run_id,emplid,paycheck_nbr,s_edt_code_pay) using btree > > > > in hruat_index_08; > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001636c5b52680d350046e5ecf59 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >