IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Query efficiency against historical data?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Jun 16, 2011 8:38 am
Reply with quote

sushanth bobby wrote:

And still did not tell,
How many months of data you want to keep ?
How many transactions per day you have like how transaction row get populated per day ?(since you were planning on partition per day).

Thanks,
Sushanth


These are all still under discussion and not determined.
Anyway, I decide to use rotate-partitioning UTS.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 16, 2011 8:46 am
Reply with quote

Quote:
These are all still under discussion and not determined.
How is there any useful discussion when no one involved has any understanding or experience. . . icon_confused.gif

d
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Jun 16, 2011 8:50 am
Reply with quote

Hi, Dick,
As I mentioned before, our shop lack money, and cannot hire very experienced experts. I'm doing partly DBA's work...
And this is just why I'm fetching help from you experts.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 16, 2011 9:35 am
Reply with quote

Quote:
As I mentioned before, our shop lack money, and cannot hire very experienced experts.
Nearly every shop would have us believe they lack money. What many have is the inability to manage what money they do have. . .

While your project might benefit from hiring a first-class team that has already successfully done several like this, this is not a necessary expense (usually). As i have mentoned several times, your organization should find a designer and an implementer who is local and have successfully done this and hire these people periodically to guide and review what is going on.

There are many here at the forum who would like to help, but with the lack of information (it is too much to post on a forum) and the lack of continuity (we have no idea what has happened between topics) we are just shooting in the dark. . .

d
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 16, 2011 10:28 am
Reply with quote

Quote:
Your shop lack money, and cannot hire very experienced experts


if your shop lacks money it should not be in the IT business

Quote:
And this is just why I'm fetching help from you experts.

so you/your organization expect the we share with you a hard earned experience
in other words you/your organization are just beggars asking Us to donate money!

so just cut the BPM and stop begging for free consultancy services

(*) if Your shop lacks money how was it able to acquire a mainframe ? icon_evil.gif
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Jun 16, 2011 10:40 am
Reply with quote

enrico-sorichetti wrote:

so just cut the BPM and stop begging for free consultancy services

(*) if Your shop lacks money how was it able to acquire a mainframe ? icon_evil.gif

may I ask what BPM means?

by the way, mainframe does not belong to our company, it belongs to our customer.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 16, 2011 10:52 am
Reply with quote

Quote:
may I ask what BPM means
STFW

Quote:
by the way, mainframe does not belong to our company, it belongs to our customer.


so you/your organization act as a provider of IT consulting/labor services...
the same comment , with slight different wording applies to you/your company

if your company lacks the proper skill ... it should not be in the IT consulting business

pretty unethical ...
you/your company are selling something you/your company do not have
and you/your company are trying to get free on a public forum
pretty smart while it works... an <infinite> percentile gain

i have made the same consideration again about your behavior, but you seem not to understand or worse care

given good reasons why We should share Our experience with you/your company
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Jun 16, 2011 2:18 pm
Reply with quote

don't worry : the first time he uses the term "rotate-partitioning UTS" he reveils ignorance.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 16, 2011 7:47 pm
Reply with quote

Quote:
the first time he uses the term "rotate-partitioning UTS" he reveils ignorance.
Maybe not to that particular audience. . . There seems to be no real experience there.

As was said long ago - "In the land of the blind the one-eyed man is king".

I continue to be puzzled how one opens a consulting firm to develop database applications (for clients) with no database development experience. I am also puzzled why a client would be willing to hire such. . .

d
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Thu Jun 16, 2011 9:43 pm
Reply with quote

dick scherrer wrote:
I am also puzzled why a client would be willing to hire such. . .

Because the cheap sons-of-fifty-fathers who manage the client firm can hire the dishonest "consulting" firm for minimum wage plus overhead.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 16, 2011 9:51 pm
Reply with quote

so that they can sell at normal price
bad products made by a cheap company, with cheap labor, with cheap material, with poor/nonexisting skills
making big profits and not caring an eff about anything else
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 16, 2011 10:07 pm
Reply with quote

Unfortunately, this is what gives consultants/contractors a very bad reputation. Also unfortunately, this population is growing icon_sad.gif

d
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 16, 2011 10:36 pm
Reply with quote

not in general, naturally!

my strong remarks spring from the history and attitude of this TS

in another post the same TS was talking about the lack of money of his organization,
but that time he made everybody believe that he was an employee of that organization trying out of his generosity to help hie employer to save money ..
what a truckload of bullshit icon_evil.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2 Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 1
No new posts Store the data for fixed length COBOL Programming 1
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top