| Author |
Message |
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
 Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
when i'm trying to type a db2 command, it cause problem and the system
hang.. previously there is no problem on it, but after i had install the
"FixPak 8", it have this problem.. And the error come out like this :
"DB21015E The Command Line Processor backend process request queue or input
queue was not created within the timeout period."
ps give me the solution..
thanks a lot..
jacelyn
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
 |
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: db2 class setup
|
|
|
i would like to do a db2 class setup (netwin2k).. i wanna do that because
of i have two server and if one of the server is "system down", and the
other one can take over.. so, what i'm going to do?
ps give me the solution..
thanks a lot..
jacelyn
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
|
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
jacelyn Yswan via DBMonster.com wrote:
| Quote: | when i'm trying to type a db2 command, it cause problem and the system
hang.. previously there is no problem on it, but after i had install the
"FixPak 8", it have this problem.. And the error come out like this :
"DB21015E The Command Line Processor backend process request queue or
input queue was not created within the timeout period."
|
It might help if you state which platform you are on and what kind of
command you try to execute.
Other than that, did you have a look at the explanation of the DB21015 error
and followed the instructions there?
$ db2 "? db21015"
DB21015E The Command Line Processor backend process request
queue or input queue was not created within the timeout
period.
Explanation:
Either the values for the DB2BQTRY and DB2BQTIME environment
variables need to be increased or the command line processor
back-end program "db2bp" cannot be started. The "db2bp" program
must reside in the correct database manager install path and
users must have execute permission on the file.
User Response:
Correct the error and resubmit the command.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena |
|
| Back to top |
|
|
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
i had look through the explanation of the error. but stil can't correct the
error
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
|
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
the platform that i'm using is Linux and the command is db2 command..
ps help!!!
jacelyn
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
|
Gert van der Kooij
*nix forums Guru Wannabe
Joined: 27 May 2005
Posts: 267
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: Re:facing problem of typing db2 command
|
|
|
In article <083c273a7ef145989a4f56356aa7b756@DBMonster.com>, jacelyn
Yswan via DBMonster.com (forum@DBMonster.com) says...
| Quote: | the platform that i'm using is Linux and the command is db2 command..
ps help!!!
jacelyn
|
Did you run db2iupdt after installing FP8, check the readme for
detailed instructions. |
|
| Back to top |
|
|
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
jacelyn Yswan via DBMonster.com wrote:
| Quote: | the platform that i'm using is Linux and the command is db2 command..
|
Well, I still don't know what exactly you typed in. Could you please
provide the exact invocation along with the exact error message you got?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena |
|
| Back to top |
|
|
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: db2 class set (net win2k)
|
|
|
i would like to do a db2 class set (net win2k).. i wanna do that because
of i have two server and if one of the server is "system down", and the
other one can take over.. so, what i'm going to do?
ps give me the solution..
thanks a lot..
jacelyn
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
|
Sachindra Kumar Meshram v
*nix forums Guru Wannabe
Joined: 12 May 2005
Posts: 227
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re:facing problem of typing db2 command
|
|
|
when i'm trying to type a db2 command, it cause problem and the system
hang.. previously there is no problem on it, but after i had install the
"Fix Pack 8", it have this problem.. And the error come out like this :
"DB21015E The Command Line Processor backend process request queue or input
queue was not created within the timeout period."
ps give me the solution..
thanks a lot..
jacelyn
--
Message posted via http://www.dbmonster.com |
|
| Back to top |
|
|
RdR
*nix forums addict
Joined: 04 Jul 2005
Posts: 62
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: Re:java.sql.SQLException: No suitable driver
|
|
|
- Hi Jacelyn,
Here is a sample web.xml (parameters of the app to log in to the database,
please see below) that I use in Tomcat for my app. I am using DB2 Version
8.2, and the "jcc" driver (db2jcc) to connect, for version 7 of UDB it is
the java.zip file. In my sample, the first four lines is for the driver,
thenext lines is logging on to the database where the hostname is defined,
port 50000 (DB2's default port)/ the application name, then the next lines
will be for the user and the password.
If all are correct, please make sure that your db2 driver is in your
classpath and ld_path. Another work around is to copy the db2 driver in the
tomcat directory where the app is being called (if you do not want to mess
with the java paths and load libraries.
Hope this helps.
RdR
<context-param>
<param-name>jdbc_driver</param-name>
<param-value>com.ibm.db2.jcc.DB2Driver</param-value>
</context-param>
- <context-param>
<param-name>jdbc_url</param-name>
<param-value>jdbc:db2://hostname:50000/app_name</param-value>
</context-param>
- <context-param>
<param-name>jdbc_user</param-name>
<param-value>test</param-value>
</context-param>
- <context-param>
<param-name>jdbc_password</param-name>
<param-value>test</param-value>
</context-param>
"jacelyn Yswan via DBMonster.com" <forum@DBMonster.com> wrote in message
news:28a5adb953334cf6810ad73121c4a23e@DBMonster.com...
| Quote: | i'm trying migrate my jsp program to a new server (which is my production
server) and then i use jsp to connect to db2 and retrieve records from it.
but my java program is getting the error (java.sql.SQLException: No
suitable driver) when trying to connect to db2 ...
What is suitable driver for my application? Please give me some words
of advice! help!!!
thanks a lot..
Jacelyn
--
Message posted via http://www.dbmonster.com |
|
|
| Back to top |
|
|
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: What does this mean?
|
|
|
mailar@gmail.com wrote:
| Quote: | As far as I know, SUM() works as mentioned below
The SUM function returns the sum of a set of numbers.
The argument values must be numbers (built-in types only) and their sum
must be within the range of the data type of the result.
The data type of the result is the same as the data type of the
argument values except that:
The result is a large integer if the argument values are small
integers.
The result is double-precision floating point if the argument values
are single-precision floating point.
This is an abstract from DB2 Information center
But how does SUM() take a literal value and multiply it with number of
rows in that table ....etc?
|
SUM doesn't multiply anything. It just takes 100 for each of the rows (7 in
your case) and sums those 100s up. Your query is logically the same like
this one:
SELECT SUM(col1), count(*)
FROM ( SELECT 100
FROM master_tab ) AS t(col1)
Whether you specify a column name as argument or a literal doesn't matter.
DB2 (and any other SQL engine) will take the value it finds in each row -
either a column value or the literal - and sum it up.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena |
|
| Back to top |
|
|
gnuoytr@rcn.com
*nix forums beginner
Joined: 26 May 2005
Posts: 7
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: before trigger on 390/V7
|
|
|
Serge Rielau wrote:
| Quote: | gnuoytr@rcn.com wrote:
Serge Rielau wrote:
gnuoytr@rcn.com wrote:
rather than deal with some COBOL code, which i wouldn't write,
i thought it would be common practice to use a trigger to
update a sequence column with a trigger. i'm testing on
XDB (Mainframe Express, said to be identical to V7/390).
the sequence_no should increment as shown. but the code
errors out. none of the example triggers i can find do
this kind of fullselect, but don't say you can't either.
is this permitted?
Create Trigger sch.tab1_BRI
No Cascade Before Insert on sch.tab1
Referencing old as O new as N
for each Row mode db2sql
begin atomic
set n.sequence_no =
(select coalesce(max(sequence_no ), 0 ) + 1 from sch.tab1
where sch.tab1.company_code = n.company_code and
sch.tab1.record_type = n.record_type and
sch.tab1.person_id = n.person_id );
end
thanks,
robert
What error are you getting? Just staring at it the trigger looks
fine.
It would work on DB2 for LUW.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
thx.
yeah, i couldn't see that it was wrong, either. on the other hand,
i
did some further digging and came up with a note that fullselect
from
the trigger table wasn't allowed, in the XDB notes that a colleague
has.
well, just a generic XDB message that there is a syntax error. i
still
haven't got trigger authority on the 390 box, and we are mandated
to
use MFE for development. i'll go through the exercise with a LUW
db
when i get back to the office. may have to chalk it up as a
platform
difference. may have to find a COBOL coder and pucker up..........
robert
Does V7 support sequences? I know I'm pushing it by asking a zOS
customer to move to V8.. but hey I do it anyway. A lot of Db2 zOS SQL
limitations have been removed in V8. makes x-platform so much easier
:-)
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
|
google really did mess up last night.
just finished defining a trigger of this structure on LUW/v8. pretty
as
a peach. oh well.
robert |
|
| Back to top |
|
|
Larry
*nix forums Guru
Joined: 20 Feb 2005
Posts: 325
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: 64-bit instance on Aix 32 bit kernel / 64 bit hardware
|
|
|
How do you know that Oracle supports it?
Larry Edelstein
Jean-Marc Blaise wrote:
| Quote: | "Jean-Marc Blaise" <nobody@nowhere.com> a écrit dans le message de
news:4200861e$0$6585$8fcfb975@news.wanadoo.fr...
"Darin McBride" <dmcbride@naboo.to.org.no.spam.for.me> a écrit dans le
message de news:T0ZLd.250407$Xk.6730@pd7tw3no...
Larry E wrote:
Jean-Marc,
I believe what the technote is trying to say is you can install the
64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but
once you install the DB2 binaries, you must create DB2 instances in
order to operate a DB2 database. I believe it is saying that you
cannot
create 64-bit instances under a 32-bit OS. If you didn't receive an
error in attempting to do so, I guess you are in uncharted territory,
and risk not being able to get support from IBM. I'm not sure that
there's any advantage to using a 64-bit instance under a 32-bit OS,
even
if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works.
However, I don't think it's officially supported. I'm not sure if this
is explicitly unsupported, or simply implicitly unsupported by the fact
that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the
db2setup
propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done
to
check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT
propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation" on a 32-bit kernel,
but there must be a reason somewhere as AIX does support it.
Best regards,
Jean-Marc
.... By the way, it seems Oracle installs in 64-bit only on such machines ...
so why would DB2 avoid this support ?
|
|
|
| Back to top |
|
|
Serge Rielau
*nix forums Guru
Joined: 29 Apr 2005
Posts: 1583
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: Temporary index is not taking in the Stored procedure
|
|
|
Guru wrote:
| Quote: | Hi All
I am using a Global Temporary table in the Stored procedure and i am
creating index for a column in that temporary table.When i am executing
it. It is not taking that index. I checked using explain plan. But if i
run the runstats in the CLP for that temporary table it is taking the
index. How i have to implement in the Stored procedure itself?
Warm Regards
Guru
I can only think of two reasons: |
* If you create the index after the query is run the first time it won't
be picked up in later runs since adding an index does not invalidate
existing palns.
* WHen you try from CLP do you use constants where the query in the
procedure used variables? That would change the query sufficiently to
get a different plan. Use parameter markers in CLP (with a CAST(? AS
<variabletype>) if needed to compare apples to apples.
If that turns out to be the difference you can experiment with the
SELECTIVITY clause on the predicates to increase the filter factor or
you can use the REOPT(ONCE) prep option to use the varibale values on
first run to determine filtering.
In DB2 V8.2 I think there is a stored procedure to set the prep options
for SQL Procedures.
Cheers
Serge
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |
|
| Back to top |
|
|
Bob Hairgrove
*nix forums Guru
Joined: 03 Jun 2005
Posts: 372
|
| Posted: Thu May 26, 2005 5:53 pm Post subject:
Re: ODBC update error with DB2 timestamp data
|
|
|
On Sat, 22 Jan 2005 11:00:15 +0800, "kaming" <guest@guest.com> wrote:
| Quote: | Dear all,
I found that I can't update or delete a DB2 record with timestamp using
Access through ODBC. The Access complains "No current record" while I
attempt to update or delete the record with timestamp.
Do anyone have idea of how to fix this problem?
Thanks in advance!
Henry
|
I'm really surprised that no one up to now was able to tell you why
this will never work ... DB2 supports fractions of a second to six
decimal places (i.e. microseconds) and Access only goes to a
granularity of one second (no fractions). No patch exists because this
is an impossible thing to do. Access will never be able to distinguish
rows where the difference in timestamp values is less than one second.
The Access DATETIME data type is mapped to the ODBC data type
SQL_TIMESTAMP, but ... no fractions.
Note that MS-SQLServer uses yet another kind of "timestamp" data type
(a kind of AutoNumber automatically generated surrogate key) which has
nothing to do with the ODBC SQL_TIMESTAMP type.
Good luck.
--
Bob Hairgrove
NoSpamPlease@Home.com |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
