Hi All,
I have federation setup on db2 database (X) for 4 different db2 servers (e.g. A1, A2, A3, A4).
I created below nicknames on X database which uses 4 db2 servers.
A1_EMP_DIM
A2_EMP_DIM
A3_EMP_DIM
A4_EMP_DIM
Is below query run parallel on 4 server (A1, A2, A3, A4)?
Select EMP_ID,EMP_NAME from X.A1_EMP_DIM
Union All
Select EMP_ID,EMP_NAME from X.A2_EMP_DIM
Union All
Select EMP_ID,EMP_NAME from X.A3_EMP_DIM
Union All
Select EMP_ID,EMP_NAME from X.A4_EMP_DIM
Regards
0 981 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Neil Ginsberg |
last post by:
I have a SQL 7 db with a union query (view), and I'm getting the error, "The
query processor could not start the necessary thread resources for parallel
query execution." This union query has been in place for about two years now
with no problems until just now, though I haven't changed anything. Also, I
have a local copy of the database on my machine, and the query runs fine.
As noted, I haven't changed anything in the query, nor in the...
|
by: spencer |
last post by:
My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6. In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server. We
utilized federation to allow the joining of tables on seperate
instances. We found that this worked ok in situations where the tables
were not that large say under...
|
by: lyn.duong |
last post by:
Hi,
I have a large table (about 50G) which stores data for over 7 years. I
decided to split this table up into a yearly basis and in order to
allow minimum changes to the applications which access this table, I
created a union all view over the 7 yearly tables.
What I have noticed is that queries against the union all view is
considerably slower than queries against the original table. When I ran
db2batch, I noticed cpu usage was higher...
|
by: Anna |
last post by:
Hi all,
I have a query in ASP.NET that selects text from a memo field in Access
(among other things). The query appears to be truncating the text at
255 characters. I've done a little research on this and found some
other Google Groups threads that were helpful, but I still don't have a
solution. My query is rather complicated and uses a union, but not the
keyword distinct. The query is displayed in a datagrid, and I don't
know how I...
|
by: GJW |
last post by:
Does anybody know a simply way I can run a query on a single table and
merge the results of several columns of data into a single column of
data?
IE
Table1:
First Name Second Name
------------ ----------------
| |
by: vivekian |
last post by:
Hi ,
I need to place the results of two different queries in the same result
table parallel to each other.
So if the result of the first query is
1 12
2 34
3 45
|
by: KoliPoki |
last post by:
Hello every body.
I have a small issue.
Problem: I have a table with 4 descriptor columns (type). I need to
formulate a query to retrieve a count for each type so I can group
by...etc. The view I have works, but doesn't work when I supplement the
query with some functions... they just don't like the UNION. The real
problem is I can't change any of the udf's or queries, just the view.
The view is inner joined back on to the primary...
|
by: BobTheDataBaseBoy |
last post by:
A client has 390/V7 and UDB/V8. It would be useful to use row_number()
when selecting from 390, but that's not supported. It occurs to me (I'm
not in CubeLand, and anyway we upgraded to V8 on z/OS) that federation
(on UDB/V8) might support functions on those 390/V7 tables. Is this
known?
thanks
|
by: ebasshead |
last post by:
Hi Everyone
I have four queries that Ive joined in a union query and want to add a date criteria ei between and including date A and date B. Ive tried a few things but getting errors. Can someone please guide me as to where it should go and how it should be written please. My code so far is below...
SELECT , , , , , , , ,
FROM
UNION SELECT , , , , , , , ,
FROM
UNION SELECT , , , , , , , ,
|
by: samul |
last post by:
very simple i would think to those who would know what to do but having a hard time:
i've addresses. street names and addresses on the streets. so those are the two fields. i want to arrange the whole thing according to how the route should be done. so i've done queries for subsections like A means north, and the way the North should be done, B query, means south area, and the way the streets should be arranged when if someone were to do area...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |