View previous topic :: View next topic
|
Author |
Message |
Rahul Reddy R
New User
Joined: 01 Apr 2008 Posts: 4 Location: Mysore
|
|
|
|
Hi,
i hav a program which is present in two regions. Now one of the program is abending with SQL Code -805. If i recompile the problem copy, the other program will have this issue. Can anyone help me to fix this issue.
Thanks,
Rahul |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
compile once,
bind twice using the same dbrm |
|
Back to top |
|
|
Rahul Reddy R
New User
Joined: 01 Apr 2008 Posts: 4 Location: Mysore
|
|
|
|
hi thanks for the reply,
can u just tell me wat do u mean by 'bind twice using the same dbrm'.. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
rough approach,
when compiling/precompiling a db2 program a dbrm is created with
info to correlate the dbrm with the program
the same info is contained in the load module
the bind transfers the same info to the db2 catalog tables
so when You compile/link bind a program the info is in sync with one db2 instance,
will get out of sync with the other one ( load module changed )
this info should have been provided by Your support
I wonder why there is still such incompetence in the db2 support groups
that they are unable to provide the proper guidelines to the team
they shoud be supporting |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
I wonder if it has anything to do with- I have my own compile/link/bind jcl
- the site documentation is confusing
- no one at work will help me
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Guyz,
Quote: |
I wonder why there is still such incompetence in the db2 support groups |
I don't agree with this?
Quote: |
I wonder if it has anything to do with
I have my own compile/link/bind jcl |
Not introduced to the tools used in their respective shop.
Quote: |
the site documentation is confusing |
Application Documents are not well updated.
Quote: |
no one at work will help me |
CLASSIC. competition. "what if the guy sitting next to me become more brilliant than me ? I can't stop him. But, can slow him."
Basically all kinds & types of support groups will be willing to help!
But, the scenarios are mostly like
*Scared to ask ?
*What will they think of me, if this is a stupid question ?
*They might tell that i am not being professional or didn't do my homework or started something without even having ground-level knowledge ?
Everyone is doing their homework here. And You guys are being their best guides and at most times THE ANSWER. Pointing them to the right direction supporting everyone in the way that is needed by them.
THANK YOU. THANK YOU. VERY MUCH.
No question is stupid. Its just not asking it.
Sushanth |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
Quote:
I wonder why there is still such incompetence in the db2 support groups
I don't agree with this?
Quote:
I wonder if it has anything to do with
I have my own compile/link/bind jcl
Not introduced to the tools used in their respective shop.
Quote:
the site documentation is confusing
Application Documents are not well updated. |
if the organization had done it' s job correctly
the TS would have been given a document describing the most
common practices to be followed
if the support had done it' s job correctly it would have adviced the organization about the above
and written the same
on its own it would have provided additional/extra HOW TOs WHAT IFs and samples for the most common tasks
would have a more friendly attitude toward the people it should support
(not to scare them for asking )
so I stand strongly on my previous assertion support is incompetent
both toward the end users and the organization management
and if the TS is afraid of asking because the organization encourages
such forms of disgraceful competition
then it would be better to start looking for a different employer |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
*Scared to ask ?
*What will they think of me, if this is a stupid question ?
*They might tell that i am not being professional or didn't do my homework or started something without even having ground-level knowledge ? |
how much of the above is due to resume fraud
and/or
receiving answers to interview questions from a friend or relative?
Most of the 'dumb' questions show that the OP (or TS as enrico likes to say)
has done nothing to solve the problem himself.
There are enough members of the websites that will freely give code/answers to questions
(for reasons of their own)
that one can just simply wait and someone
will do the work for them!
Performing in a job is not like going to elementary school,
though many posting here seem to think that the same rules apply. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sushanth,
You, and many, many, others on this board, do their own work.
please, do not construe my comments to have included you.
Nowadays, it seems that having multiple degrees after ones' name is
required to be hired in IT.
How in the world did these people get their degrees? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Quote: |
if the organization had done it' s job correctly the TS would have been given a document describing the most common practices to be followed |
Yes. I agree. Definately there will be a document stating most of the works & how it is too be done in a orderly manner. And i can surely say that, somethings will be also missing.
Quote: |
if the support had done it' s job correctly it would have adviced the organization about the above and written the same |
Yes. I agree. DITO as above.
Quote: |
so I stand strongly on my previous assertion support is incompetent
both toward the end users and the organization management |
I disagree. How can support be incompetent towards the end-users & oraganization ? Only thing the support can do is support. And do know there is no one, to support the support.
Quote: |
how much of the above is due to resume fraud
and/or receiving answers to interview questions from a friend or relative? |
All the above matches resume fraud & also freshers(they will eventually learn).
Nowadays, it seems that having multiple degrees after ones' name is required to be hired in IT.
YES. That's true.
How in the world did these people get their degrees?
That is something we have to ask, when we meet people like this ?
Sushanth |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sushanth,
Quote: |
How in the world did these people get their degrees? |
actually I was being sarcastic.
Just assumed they got their degrees,
their jobs,
and now their work done the same way. |
|
Back to top |
|
|
|