FW: Bug ?
The jobs will abort if you specify "Abort after NN warnings" in the properties of "Run Job" in Director. The default is set to 50 IIRC.
This is not a bug.
Regards,
Anthony Corrente.
--- Dirk Moolman wrote:
> I logged a case with Tech Support for this - cant figure it out.
>
> I add the line "DISABLE_INFO=YES" to the rbodbc32.ini file, and all
> jobs are fine accept one. When I remove this line, all jobs abort with
> too many warnings being displayed.
> The funny thing is that the warnings arent errors, just messages sent back
> from Redbrick.
>
> Beginning to think its a bug in the software.
>
> Dirk
>
> -----Original Message-----
> From: Dirk Moolman [mailto:dirkm@reach.co.za]
> Sent: Tuesday, November 06, 2001 3:27 PM
> To: Datastage List
> Subject: Bug ?
>
>
> I installed the NT version of Datastage, and then exported my project
> from the Unix version and imported it to the NT version.
>
> The release notes of Datastage says that if you are using Redbrick,
> you must add the line DISABLE_INFO=YES
> to the rbodbc32.ini file, if you want to suppress informational messages.
>
> Before I did this all my jobs aborted with info and warning messages.
> After I added this line, all my jobs work fine accept one, which is
> still doing exactly the same as before. The jobs are all very similar
> and I cant see what is causing this.
>
> Has anyone dealt with this issue before ?
>
>
>
> Dirk Moolman
> Database Administrator
> Reach Technologies
> South Africa
>
> www.thefuelgroup.co.za
>
> "No pessimist ever discovered the secret of the stars, or sailed to an
> uncharted land, or opened a new doorway for the human spirit." -Helen
> Keller
>
>
>
>
> ==========================================================
> This message contains information intended for the perusal, and/or use
> (if so stated), by the stated addressee(s) only. The information is
> confidential and privileged. If you are not an intended recipient, do
> not peruse, use, disseminate, distribute, copy or in any manner rely
> upon the information contained in this message (directly or
> indirectly). The sender and/or the entity represented by the sender
> shall not be held accountable in the event that this prohibition is
> disregarded. If you receive this message in error, notify the sender
> immediately by e-mail, fax or telephone representations contained in
> this message, whether express or implied, are those of the sender
> only, unless that sender expressly states them to be the views or
> representations of an entity or person, who shall be named by the
> sender and who the sender shall state to represent. No liability shall
> otherwise attach to any other entity or person.
> ==========================================================
>
http://briefcase.yahoo.com.au - Yahoo! Briefcase
- Manage your files online.
This is not a bug.
Regards,
Anthony Corrente.
--- Dirk Moolman wrote:
> I logged a case with Tech Support for this - cant figure it out.
>
> I add the line "DISABLE_INFO=YES" to the rbodbc32.ini file, and all
> jobs are fine accept one. When I remove this line, all jobs abort with
> too many warnings being displayed.
> The funny thing is that the warnings arent errors, just messages sent back
> from Redbrick.
>
> Beginning to think its a bug in the software.
>
> Dirk
>
> -----Original Message-----
> From: Dirk Moolman [mailto:dirkm@reach.co.za]
> Sent: Tuesday, November 06, 2001 3:27 PM
> To: Datastage List
> Subject: Bug ?
>
>
> I installed the NT version of Datastage, and then exported my project
> from the Unix version and imported it to the NT version.
>
> The release notes of Datastage says that if you are using Redbrick,
> you must add the line DISABLE_INFO=YES
> to the rbodbc32.ini file, if you want to suppress informational messages.
>
> Before I did this all my jobs aborted with info and warning messages.
> After I added this line, all my jobs work fine accept one, which is
> still doing exactly the same as before. The jobs are all very similar
> and I cant see what is causing this.
>
> Has anyone dealt with this issue before ?
>
>
>
> Dirk Moolman
> Database Administrator
> Reach Technologies
> South Africa
>
> www.thefuelgroup.co.za
>
> "No pessimist ever discovered the secret of the stars, or sailed to an
> uncharted land, or opened a new doorway for the human spirit." -Helen
> Keller
>
>
>
>
> ==========================================================
> This message contains information intended for the perusal, and/or use
> (if so stated), by the stated addressee(s) only. The information is
> confidential and privileged. If you are not an intended recipient, do
> not peruse, use, disseminate, distribute, copy or in any manner rely
> upon the information contained in this message (directly or
> indirectly). The sender and/or the entity represented by the sender
> shall not be held accountable in the event that this prohibition is
> disregarded. If you receive this message in error, notify the sender
> immediately by e-mail, fax or telephone representations contained in
> this message, whether express or implied, are those of the sender
> only, unless that sender expressly states them to be the views or
> representations of an entity or person, who shall be named by the
> sender and who the sender shall state to represent. No liability shall
> otherwise attach to any other entity or person.
> ==========================================================
>
http://briefcase.yahoo.com.au - Yahoo! Briefcase
- Manage your files online.
I agree with the NN setting. But in this case, these messages shouldnt actually be received by Datastage, because of the disable_info line in the rbodbc32.ini file.
At the moment Im getting 2 messages for every record being updated, 100 records updated - 200 messages displayed.
This is the part that I think is a bug
Dirk
-----Original Message-----
From: Anthony Corrente [mailto:anthony_corrente@yahoo.com.au]
Sent: Wednesday, November 07, 2001 12:39 PM
To: datastage-users@oliver.com
Subject: Re: FW: Bug ?
The jobs will abort if you specify "Abort after NN warnings" in the properties of "Run Job" in Director. The default is set to 50 IIRC.
This is not a bug.
Regards,
Anthony Corrente.
--- Dirk Moolman wrote:
> I logged a case with Tech Support for this - cant figure it out.
>
> I add the line "DISABLE_INFO=YES" to the rbodbc32.ini file, and all
> jobs
are
> fine accept one.
> When I remove this line, all jobs abort with too many warnings being
> displayed. The funny thing is that the warnings arent errors, just
> messages sent
back
> from Redbrick.
>
> Beginning to think its a bug in the software.
>
> Dirk
>
> -----Original Message-----
> From: Dirk Moolman [mailto:dirkm@reach.co.za]
> Sent: Tuesday, November 06, 2001 3:27 PM
> To: Datastage List
> Subject: Bug ?
>
>
> I installed the NT version of Datastage, and then exported my project
> from the Unix version and imported it to the NT version.
>
> The release notes of Datastage says that if you are using Redbrick,
> you
must
> add the line
> DISABLE_INFO=YES
> to the rbodbc32.ini file, if you want to suppress informational
> messages.
>
> Before I did this all my jobs aborted with info and warning messages.
After
> I added this
> line, all my jobs work fine accept one, which is still doing exactly
> the same as before. The jobs are all very similar and I cant see what
> is causing this.
>
> Has anyone dealt with this issue before ?
>
>
>
> Dirk Moolman
> Database Administrator
> Reach Technologies
> South Africa
>
> www.thefuelgroup.co.za
>
> "No pessimist ever discovered the secret of the stars, or sailed to an
> uncharted land, or opened a new doorway for the human spirit." -Helen
> Keller
>
>
>
>
> ==========================================================
> This message contains information intended for the perusal, and/or use
> (if so stated), by the stated addressee(s) only. The information is
> confidential and privileged. If you are not an intended recipient, do
> not peruse, use, disseminate, distribute, copy or in any manner rely
> upon the information contained in this message (directly or
> indirectly). The sender and/or the entity represented by the sender
> shall not be held accountable in the event that this prohibition is
> disregarded. If you receive this message in error, notify the sender
> immediately by e-mail, fax or
telephone
> representations contained in this message, whether express or implied,
> are those of the sender only, unless that sender expressly states them
> to be the views or representations of an entity or person, who shall
> be named by the sender and who the sender shall state to represent. No
> liability shall otherwise attach to any other entity or person.
> ==========================================================
>
http://briefcase.yahoo.com.au - Yahoo! Briefcase
- Manage your files online.
At the moment Im getting 2 messages for every record being updated, 100 records updated - 200 messages displayed.
This is the part that I think is a bug
Dirk
-----Original Message-----
From: Anthony Corrente [mailto:anthony_corrente@yahoo.com.au]
Sent: Wednesday, November 07, 2001 12:39 PM
To: datastage-users@oliver.com
Subject: Re: FW: Bug ?
The jobs will abort if you specify "Abort after NN warnings" in the properties of "Run Job" in Director. The default is set to 50 IIRC.
This is not a bug.
Regards,
Anthony Corrente.
--- Dirk Moolman wrote:
> I logged a case with Tech Support for this - cant figure it out.
>
> I add the line "DISABLE_INFO=YES" to the rbodbc32.ini file, and all
> jobs
are
> fine accept one.
> When I remove this line, all jobs abort with too many warnings being
> displayed. The funny thing is that the warnings arent errors, just
> messages sent
back
> from Redbrick.
>
> Beginning to think its a bug in the software.
>
> Dirk
>
> -----Original Message-----
> From: Dirk Moolman [mailto:dirkm@reach.co.za]
> Sent: Tuesday, November 06, 2001 3:27 PM
> To: Datastage List
> Subject: Bug ?
>
>
> I installed the NT version of Datastage, and then exported my project
> from the Unix version and imported it to the NT version.
>
> The release notes of Datastage says that if you are using Redbrick,
> you
must
> add the line
> DISABLE_INFO=YES
> to the rbodbc32.ini file, if you want to suppress informational
> messages.
>
> Before I did this all my jobs aborted with info and warning messages.
After
> I added this
> line, all my jobs work fine accept one, which is still doing exactly
> the same as before. The jobs are all very similar and I cant see what
> is causing this.
>
> Has anyone dealt with this issue before ?
>
>
>
> Dirk Moolman
> Database Administrator
> Reach Technologies
> South Africa
>
> www.thefuelgroup.co.za
>
> "No pessimist ever discovered the secret of the stars, or sailed to an
> uncharted land, or opened a new doorway for the human spirit." -Helen
> Keller
>
>
>
>
> ==========================================================
> This message contains information intended for the perusal, and/or use
> (if so stated), by the stated addressee(s) only. The information is
> confidential and privileged. If you are not an intended recipient, do
> not peruse, use, disseminate, distribute, copy or in any manner rely
> upon the information contained in this message (directly or
> indirectly). The sender and/or the entity represented by the sender
> shall not be held accountable in the event that this prohibition is
> disregarded. If you receive this message in error, notify the sender
> immediately by e-mail, fax or
telephone
> representations contained in this message, whether express or implied,
> are those of the sender only, unless that sender expressly states them
> to be the views or representations of an entity or person, who shall
> be named by the sender and who the sender shall state to represent. No
> liability shall otherwise attach to any other entity or person.
> ==========================================================
>
http://briefcase.yahoo.com.au - Yahoo! Briefcase
- Manage your files online.
Dirk, Redbrick was designed with a high-performance
bulk-loader called TMU. This handles both inserts and
updates. Your issues with the ODBC driver are long
standing issues with Redbrick. Since Redbrick was
designed back in the day by Kimball to be a pure data warehousing platform, its mechanism for loading has always been TMU. The ODBC driver is meant for query access, not loading. I worked with Informix years ago about this driver, and theres not much hope for you.
TMU is incredibly fast! It is more featured than any
other bulk loader. The fact that it handles updates
is fantastic.
Good luck!
-Ken
--- Dirk Moolman wrote:
> I agree with the NN setting. But in this case, these
> messages shouldnt
> actually be received by Datastage, because of the disable_info line in
> the rbodbc32.ini file.
>
> At the moment Im getting 2 messages for every
> record being updated,
> 100 records updated - 200 messages displayed.
>
> This is the part that I think is a bug
>
> Dirk
>
>
> -----Original Message-----
> From: Anthony Corrente
> [mailto:anthony_corrente@yahoo.com.au]
> Sent: Wednesday, November 07, 2001 12:39 PM
> To: datastage-users@oliver.com
> Subject: Re: FW: Bug ?
>
>
> The jobs will abort if you specify "Abort after NN
> warnings" in the
> properties of "Run Job" in Director. The default is
> set to 50 IIRC.
>
> This is not a bug.
>
> Regards,
> Anthony Corrente.
>
> --- Dirk Moolman wrote:
> > I logged a case with Tech Support for this - cant
> figure it out.
> >
> > I add the line "DISABLE_INFO=YES" to the
> rbodbc32.ini file, and all jobs
> are
> > fine accept one.
> > When I remove this line, all jobs abort with too
> many warnings being
> > displayed.
> > The funny thing is that the warnings arent
> errors, just messages sent
> back
> > from Redbrick.
> >
> > Beginning to think its a bug in the software.
> >
> > Dirk
> >
> > -----Original Message-----
> > From: Dirk Moolman [mailto:dirkm@reach.co.za]
> > Sent: Tuesday, November 06, 2001 3:27 PM
> > To: Datastage List
> > Subject: Bug ?
> >
> >
> > I installed the NT version of Datastage, and then
> exported my project from
> > the Unix version and imported it to the NT
> version.
> >
> > The release notes of Datastage says that if you
> are using Redbrick, you
> must
> > add the line
> > DISABLE_INFO=YES
> > to the rbodbc32.ini file, if you want to suppress
> informational messages.
> >
> > Before I did this all my jobs aborted with info
> and warning messages.
> After
> > I added this
> > line, all my jobs work fine accept one, which is
> still doing exactly the
> > same as before. The jobs are all very similar and
> I cant see what is
> > causing this.
> >
> > Has anyone dealt with this issue before ?
> >
> >
> >
> > Dirk Moolman
> > Database Administrator
> > Reach Technologies
> > South Africa
> >
> > www.thefuelgroup.co.za
> >
> > "No pessimist ever discovered the secret of the
> stars, or sailed to an
> > uncharted land, or opened a new doorway for the
> human spirit."
> > -Helen Keller
> >
> >
> >
> >
> >
>
==========================================================
> > This message contains information intended for the
> perusal, and/or use (if
> > so stated), by the stated addressee(s) only. The
> information is
> > confidential and privileged. If you are not an
> intended recipient, do not
> > peruse, use, disseminate, distribute, copy or in
> any manner rely upon the
> > information contained in this message (directly or
> indirectly). The sender
> > and/or the entity represented by the sender shall
> not be held accountable
> > in the event that this prohibition is disregarded.
> If you receive this
> > message in error, notify the sender immediately by
> e-mail, fax or
> telephone
> > representations contained in this message, whether
> express or implied, are
> > those of the sender only, unless that sender
> expressly states them to be
> > the views or representations of an entity or
> person, who shall be named by
> > the sender and who the sender shall state to
> represent. No liability shall
> > otherwise attach to any other entity or person.
> >
>
==========================================================
> >
>
> http://briefcase.yahoo.com.au - Yahoo! Briefcase
> - Manage your files online.
>
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
bulk-loader called TMU. This handles both inserts and
updates. Your issues with the ODBC driver are long
standing issues with Redbrick. Since Redbrick was
designed back in the day by Kimball to be a pure data warehousing platform, its mechanism for loading has always been TMU. The ODBC driver is meant for query access, not loading. I worked with Informix years ago about this driver, and theres not much hope for you.
TMU is incredibly fast! It is more featured than any
other bulk loader. The fact that it handles updates
is fantastic.
Good luck!
-Ken
--- Dirk Moolman wrote:
> I agree with the NN setting. But in this case, these
> messages shouldnt
> actually be received by Datastage, because of the disable_info line in
> the rbodbc32.ini file.
>
> At the moment Im getting 2 messages for every
> record being updated,
> 100 records updated - 200 messages displayed.
>
> This is the part that I think is a bug
>
> Dirk
>
>
> -----Original Message-----
> From: Anthony Corrente
> [mailto:anthony_corrente@yahoo.com.au]
> Sent: Wednesday, November 07, 2001 12:39 PM
> To: datastage-users@oliver.com
> Subject: Re: FW: Bug ?
>
>
> The jobs will abort if you specify "Abort after NN
> warnings" in the
> properties of "Run Job" in Director. The default is
> set to 50 IIRC.
>
> This is not a bug.
>
> Regards,
> Anthony Corrente.
>
> --- Dirk Moolman wrote:
> > I logged a case with Tech Support for this - cant
> figure it out.
> >
> > I add the line "DISABLE_INFO=YES" to the
> rbodbc32.ini file, and all jobs
> are
> > fine accept one.
> > When I remove this line, all jobs abort with too
> many warnings being
> > displayed.
> > The funny thing is that the warnings arent
> errors, just messages sent
> back
> > from Redbrick.
> >
> > Beginning to think its a bug in the software.
> >
> > Dirk
> >
> > -----Original Message-----
> > From: Dirk Moolman [mailto:dirkm@reach.co.za]
> > Sent: Tuesday, November 06, 2001 3:27 PM
> > To: Datastage List
> > Subject: Bug ?
> >
> >
> > I installed the NT version of Datastage, and then
> exported my project from
> > the Unix version and imported it to the NT
> version.
> >
> > The release notes of Datastage says that if you
> are using Redbrick, you
> must
> > add the line
> > DISABLE_INFO=YES
> > to the rbodbc32.ini file, if you want to suppress
> informational messages.
> >
> > Before I did this all my jobs aborted with info
> and warning messages.
> After
> > I added this
> > line, all my jobs work fine accept one, which is
> still doing exactly the
> > same as before. The jobs are all very similar and
> I cant see what is
> > causing this.
> >
> > Has anyone dealt with this issue before ?
> >
> >
> >
> > Dirk Moolman
> > Database Administrator
> > Reach Technologies
> > South Africa
> >
> > www.thefuelgroup.co.za
> >
> > "No pessimist ever discovered the secret of the
> stars, or sailed to an
> > uncharted land, or opened a new doorway for the
> human spirit."
> > -Helen Keller
> >
> >
> >
> >
> >
>
==========================================================
> > This message contains information intended for the
> perusal, and/or use (if
> > so stated), by the stated addressee(s) only. The
> information is
> > confidential and privileged. If you are not an
> intended recipient, do not
> > peruse, use, disseminate, distribute, copy or in
> any manner rely upon the
> > information contained in this message (directly or
> indirectly). The sender
> > and/or the entity represented by the sender shall
> not be held accountable
> > in the event that this prohibition is disregarded.
> If you receive this
> > message in error, notify the sender immediately by
> e-mail, fax or
> telephone
> > representations contained in this message, whether
> express or implied, are
> > those of the sender only, unless that sender
> expressly states them to be
> > the views or representations of an entity or
> person, who shall be named by
> > the sender and who the sender shall state to
> represent. No liability shall
> > otherwise attach to any other entity or person.
> >
>
==========================================================
> >
>
> http://briefcase.yahoo.com.au - Yahoo! Briefcase
> - Manage your files online.
>
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
You are right. I will probably have to accept the fact and move on. I am from the school where you try to keep processes as simple as possible - with as few "stages" as possible - if you know what I mean.
I wanted to keep the loading inside Datastage, where I have more control over the job. I am not loading that many records anyway - in this specific case it is the update of the customer file on our system - which reads from Informix and writes to Redbrick.
It would be better if I can keep it this way. I will see if Tech Support has an answer for me, and then take it from there. If I do get a solution, I will post it to the group.
Thanks for the e-mail Ken
Regards
Dirk
-----Original Message-----
From: Kenneth Bland [mailto:kcbland_2000@yahoo.com]
Sent: Wednesday, November 07, 2001 4:48 PM
To: datastage-users@oliver.com
Subject: RE: FW: Bug ?
Dirk, Redbrick was designed with a high-performance
bulk-loader called TMU. This handles both inserts and
updates. Your issues with the ODBC driver are long
standing issues with Redbrick. Since Redbrick was
designed back in the day by Kimball to be a pure data warehousing platform, its mechanism for loading has always been TMU. The ODBC driver is meant for query access, not loading. I worked with Informix years ago about this driver, and theres not much hope for you.
TMU is incredibly fast! It is more featured than any
other bulk loader. The fact that it handles updates
is fantastic.
Good luck!
-Ken
--- Dirk Moolman wrote:
> I agree with the NN setting. But in this case, these
> messages shouldnt
> actually be received by Datastage, because of the disable_info line in
> the rbodbc32.ini file.
>
> At the moment Im getting 2 messages for every
> record being updated,
> 100 records updated - 200 messages displayed.
>
> This is the part that I think is a bug
>
> Dirk
>
>
> -----Original Message-----
> From: Anthony Corrente
> [mailto:anthony_corrente@yahoo.com.au]
> Sent: Wednesday, November 07, 2001 12:39 PM
> To: datastage-users@oliver.com
> Subject: Re: FW: Bug ?
>
>
> The jobs will abort if you specify "Abort after NN
> warnings" in the
> properties of "Run Job" in Director. The default is
> set to 50 IIRC.
>
> This is not a bug.
>
> Regards,
> Anthony Corrente.
>
> --- Dirk Moolman wrote:
> > I logged a case with Tech Support for this - cant
> figure it out.
> >
> > I add the line "DISABLE_INFO=YES" to the
> rbodbc32.ini file, and all jobs
> are
> > fine accept one.
> > When I remove this line, all jobs abort with too
> many warnings being
> > displayed.
> > The funny thing is that the warnings arent
> errors, just messages sent
> back
> > from Redbrick.
> >
> > Beginning to think its a bug in the software.
> >
> > Dirk
> >
> > -----Original Message-----
> > From: Dirk Moolman [mailto:dirkm@reach.co.za]
> > Sent: Tuesday, November 06, 2001 3:27 PM
> > To: Datastage List
> > Subject: Bug ?
> >
> >
> > I installed the NT version of Datastage, and then
> exported my project from
> > the Unix version and imported it to the NT
> version.
> >
> > The release notes of Datastage says that if you
> are using Redbrick, you
> must
> > add the line
> > DISABLE_INFO=YES
> > to the rbodbc32.ini file, if you want to suppress
> informational messages.
> >
> > Before I did this all my jobs aborted with info
> and warning messages.
> After
> > I added this
> > line, all my jobs work fine accept one, which is
> still doing exactly the
> > same as before. The jobs are all very similar and
> I cant see what is
> > causing this.
> >
> > Has anyone dealt with this issue before ?
> >
> >
> >
> > Dirk Moolman
> > Database Administrator
> > Reach Technologies
> > South Africa
> >
> > www.thefuelgroup.co.za
> >
> > "No pessimist ever discovered the secret of the
> stars, or sailed to an
> > uncharted land, or opened a new doorway for the
> human spirit."
> > -Helen Keller
> >
> >
> >
> >
> >
>
==========================================================
> > This message contains information intended for the
> perusal, and/or use (if
> > so stated), by the stated addressee(s) only. The
> information is
> > confidential and privileged. If you are not an
> intended recipient, do not
> > peruse, use, disseminate, distribute, copy or in
> any manner rely upon the
> > information contained in this message (directly or
> indirectly). The sender
> > and/or the entity represented by the sender shall
> not be held accountable
> > in the event that this prohibition is disregarded.
> If you receive this
> > message in error, notify the sender immediately by
> e-mail, fax or
> telephone
> > representations contained in this message, whether
> express or implied, are
> > those of the sender only, unless that sender
> expressly states them to be
> > the views or representations of an entity or
> person, who shall be named by
> > the sender and who the sender shall state to
> represent. No liability shall
> > otherwise attach to any other entity or person.
> >
>
==========================================================
> >
>
> http://briefcase.yahoo.com.au - Yahoo! Briefcase
> - Manage your files online.
>
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================
I wanted to keep the loading inside Datastage, where I have more control over the job. I am not loading that many records anyway - in this specific case it is the update of the customer file on our system - which reads from Informix and writes to Redbrick.
It would be better if I can keep it this way. I will see if Tech Support has an answer for me, and then take it from there. If I do get a solution, I will post it to the group.
Thanks for the e-mail Ken
Regards
Dirk
-----Original Message-----
From: Kenneth Bland [mailto:kcbland_2000@yahoo.com]
Sent: Wednesday, November 07, 2001 4:48 PM
To: datastage-users@oliver.com
Subject: RE: FW: Bug ?
Dirk, Redbrick was designed with a high-performance
bulk-loader called TMU. This handles both inserts and
updates. Your issues with the ODBC driver are long
standing issues with Redbrick. Since Redbrick was
designed back in the day by Kimball to be a pure data warehousing platform, its mechanism for loading has always been TMU. The ODBC driver is meant for query access, not loading. I worked with Informix years ago about this driver, and theres not much hope for you.
TMU is incredibly fast! It is more featured than any
other bulk loader. The fact that it handles updates
is fantastic.
Good luck!
-Ken
--- Dirk Moolman wrote:
> I agree with the NN setting. But in this case, these
> messages shouldnt
> actually be received by Datastage, because of the disable_info line in
> the rbodbc32.ini file.
>
> At the moment Im getting 2 messages for every
> record being updated,
> 100 records updated - 200 messages displayed.
>
> This is the part that I think is a bug
>
> Dirk
>
>
> -----Original Message-----
> From: Anthony Corrente
> [mailto:anthony_corrente@yahoo.com.au]
> Sent: Wednesday, November 07, 2001 12:39 PM
> To: datastage-users@oliver.com
> Subject: Re: FW: Bug ?
>
>
> The jobs will abort if you specify "Abort after NN
> warnings" in the
> properties of "Run Job" in Director. The default is
> set to 50 IIRC.
>
> This is not a bug.
>
> Regards,
> Anthony Corrente.
>
> --- Dirk Moolman wrote:
> > I logged a case with Tech Support for this - cant
> figure it out.
> >
> > I add the line "DISABLE_INFO=YES" to the
> rbodbc32.ini file, and all jobs
> are
> > fine accept one.
> > When I remove this line, all jobs abort with too
> many warnings being
> > displayed.
> > The funny thing is that the warnings arent
> errors, just messages sent
> back
> > from Redbrick.
> >
> > Beginning to think its a bug in the software.
> >
> > Dirk
> >
> > -----Original Message-----
> > From: Dirk Moolman [mailto:dirkm@reach.co.za]
> > Sent: Tuesday, November 06, 2001 3:27 PM
> > To: Datastage List
> > Subject: Bug ?
> >
> >
> > I installed the NT version of Datastage, and then
> exported my project from
> > the Unix version and imported it to the NT
> version.
> >
> > The release notes of Datastage says that if you
> are using Redbrick, you
> must
> > add the line
> > DISABLE_INFO=YES
> > to the rbodbc32.ini file, if you want to suppress
> informational messages.
> >
> > Before I did this all my jobs aborted with info
> and warning messages.
> After
> > I added this
> > line, all my jobs work fine accept one, which is
> still doing exactly the
> > same as before. The jobs are all very similar and
> I cant see what is
> > causing this.
> >
> > Has anyone dealt with this issue before ?
> >
> >
> >
> > Dirk Moolman
> > Database Administrator
> > Reach Technologies
> > South Africa
> >
> > www.thefuelgroup.co.za
> >
> > "No pessimist ever discovered the secret of the
> stars, or sailed to an
> > uncharted land, or opened a new doorway for the
> human spirit."
> > -Helen Keller
> >
> >
> >
> >
> >
>
==========================================================
> > This message contains information intended for the
> perusal, and/or use (if
> > so stated), by the stated addressee(s) only. The
> information is
> > confidential and privileged. If you are not an
> intended recipient, do not
> > peruse, use, disseminate, distribute, copy or in
> any manner rely upon the
> > information contained in this message (directly or
> indirectly). The sender
> > and/or the entity represented by the sender shall
> not be held accountable
> > in the event that this prohibition is disregarded.
> If you receive this
> > message in error, notify the sender immediately by
> e-mail, fax or
> telephone
> > representations contained in this message, whether
> express or implied, are
> > those of the sender only, unless that sender
> expressly states them to be
> > the views or representations of an entity or
> person, who shall be named by
> > the sender and who the sender shall state to
> represent. No liability shall
> > otherwise attach to any other entity or person.
> >
>
==========================================================
> >
>
> http://briefcase.yahoo.com.au - Yahoo! Briefcase
> - Manage your files online.
>
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================