Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to fix -805 error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Rahul Reddy R

New User


Joined: 01 Apr 2008
Posts: 4
Location: Mysore

PostPosted: Thu Apr 23, 2009 12:42 pm    Post subject: how to fix -805 error
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Apr 23, 2009 12:45 pm    Post subject: Reply to: how to fix -805 error
Reply with quote

compile once,
bind twice using the same dbrm
Back to top
View user's profile Send private message
Rahul Reddy R

New User


Joined: 01 Apr 2008
Posts: 4
Location: Mysore

PostPosted: Thu Apr 23, 2009 12:49 pm    Post subject:
Reply with quote

hi thanks for the reply,
can u just tell me wat do u mean by 'bind twice using the same dbrm'..
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Apr 23, 2009 1:01 pm    Post subject: Reply to: how to fix -805 error
Reply with quote

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 icon_biggrin.gif

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 icon_evil.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Apr 23, 2009 1:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 23, 2009 8:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Apr 23, 2009 8:48 pm    Post subject: Reply to: how to fix -805 error
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Apr 23, 2009 9:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Apr 23, 2009 10:55 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Apr 24, 2009 12:08 am    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Apr 24, 2009 1:39 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us