Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] Hyperstage extended bulk load options

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] Hyperstage extended bulk load options
 Login/Join
 
Martin vK
Platinum Member
posted
We are using Hyperstage and are loading large files into it.
For this we use DataMigrator and the extended bulk load facility.

For this you can supply some options for which I can not find any suitable documentation how to best set these options.

Load Type
Select Extended Bulk Load Utility to take advantage of the bulk load options specific to the Hyperstage adapter. These options are listed below.

Commit every row(s)
A commit command will be issued every time the specified number of rows is loaded successfully.

Use Distribute Load Processor for loading data in Hypestage Data Base
Selecting this option will allow you to use the Distribute Load Processor (DLP), a parallel loading tool built into Hyperstage DB.

Maximum Number of Load Sessions
The maximum amount of simultaneous parallel threads which the DLP can use to load data.


How do I know what are the best settings for our environment? Does anyone have best practices on this?

regards, Martin.

This message has been edited. Last edited by: Tamra,


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
Tamra
Guru
posted Hide Post
Martin vk

Searching on the IBI knowledge base I found the following links : How to set up HyperStage for bulk load

Creating a Quick ETL Copy

Specifying Data Target Options

Hopefully, the above will provide a bit more insight into what you are trying to do.

Kindest regards,
Tamra Colangelo
iWay Focal Point Forum Moderator


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Martin vK
Platinum Member
posted Hide Post
Hi Tamra,

Unfortunately, this documentation does not provide an answer which would be the best settings for the available options.

I am looking for best practices to set the values for these extended bulk load options.

regards, Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
Tamra
Guru
posted Hide Post
Martin,

Thank you for the response.

Can you provide more details about your environment that might help with a suggestion?

What type of data file is being loaded into Hyperstage?

What is the volume of data?

What is the OS?

Anything else may also help determine a possible suggestion?

Kindest regards,
Tamra Colangelo
iWay Focal Point Forum Moderator


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Martin vK
Platinum Member
posted Hide Post
It is data from DB2 that is loaded into Hyperstage. The volume depends on the specific table but ranges from 1 to 100 miljon records.
DataMigrator and Hyperstage run on Windows 2008 Server.

Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
Tamra
Guru
posted Hide Post
Hi Martin

It looks like a case has been opened to handle these questions.

Please share with us what the final resolution is so that others can benefit as well.

Thank you for participating in iWay Focal Point Forum.

Kindest regards,
Tamra Colangelo
iWay Focal Point Forum Moderator


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] Hyperstage extended bulk load options

Copyright © 1996-2020 Information Builders