Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

DB2 for Linux, UNIX, and Windows | Forum profile

Forum profile page for DB2 for Linux, UNIX, and Windows on http://www.ibm.com/developerworks/db2/. This report page is the aggregated overview from a single forum: DB2 for Linux, UNIX, and Windows , located on the Message Board at http://www.ibm.com/developerworks/db2/. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "DB2 for Linux, UNIX, and Windows " on the Message Board at http://www.ibm.com/developerworks/db2/ is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: developerWorks : Information Management Forums - DB2 for Linux, UNIX, and Windows
(site profile, domain info ibm.com)
Title: DB2 for Linux, UNIX, and Windows
Url: http://www.ibm.com/developerworks/forums/forum....
Users activity: 16 post per thread
Forum activity: 30 active threads during last week
 

Posting activity on DB2 for Linux, UNIX, and Windows :

  Week Month 3 Months
Threads: 30 83 243
Post: 52 141 381
 

DB2 for Linux, UNIX, and Windows Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
solvetek
6
user's latest post:
Errors when compiling the sample...
Published (2009-11-13 11:57:00)
I fixed the nmake problem but I still get the following message: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008
1029384756
4
user's latest post:
DB2 installation on AIX
Published (2009-11-10 00:41:00)
So situation is following: I want to connect to *DB2*(on *AIX*) on the remote computer. As it is known the server is runed and the port is opened (I test port), but I cant connect to them by client app, there are some connection errors, than I check an existance of db2 command on server, but it dose not work, following error was occured: SQL10007N Message "-1390" could not be retrieved. Reason code: "3" The matter is, that...
NormWong
3
user's latest post:
connecting to a DB2 instance...
Published (2009-11-05 23:49:00)
At the DB2 ExpressC download page for Windows x64, this is the second download file: DB2 9.7 Add-Ins for Microsoft Visual Studio db2exc_vsai_970_WIN_x86.zip (29 M)
Sreejith
3
user's latest post:
ADM7518C : <dbName> marked...
Published (2009-11-11 12:15:00)
Hi I am running a DB2 v9.7 Enterprise edition database on Windows 2003 server Our application heavily uses DB2 SQL PL Stored Procedures for all processing. The following is a strage behaviour happening on the DB We execute a stored procedure which processes almost 3 million records (expected to complete in 10 mins) Sometimes , in our test env. when it runs for more than 15 mins , we cancel the execution by pressing Control+C DB2 does the...
Tonkuma
3
user's latest post:
query error
Published (2009-11-12 15:21:00)
What query did you run?
Sandman
2
user's latest post:
Howto? UPDATE statement...
Published (2009-11-05 07:22:00)
1) Yes 2) Yes (Thanks for formating my query)
windward
2
user's latest post:
connecting to a DB2 instance...
Published (2009-11-05 18:28:00)
Heres the code that im calling that causes the error ArrayList vendors = new ArrayList(); ArrayList problems = new ArrayList(); DataTable tbl = DbProviderFactories.GetFactoryClasses(); foreach (DataRow row in tbl.Rows) { string providerClass = (string)row[2]; try { DbProviderFactories.GetFactory(providerClass); // will throw exception if not configured properly vendors.Add(CreateProvider((string)row[0], row[1] as string, providerClass)); }...
_mihai_
2
user's latest post:
Working with the SYSADM...
Published (2009-11-06 13:40:00)
1) Is there a way to determine whether the current user is considered to have the SYSADM privilege? Yes, as William mentioned you can use the SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID table function 2) As part of (1), is there a way to determine the list of users/groups who have the SYSADM privilege? The SYSADM group is controlled by the sysadm_group dbm cfg parameter, members of this group are considered SYSADM. 3) The documentation reports...
impetej
2
user's latest post:
DB2 installation on AIX
Published (2009-11-06 09:14:00)
You may not have created an instance as part of the install or as a post installation step. To confirm, run &lt;db2 install path&gt;/instance/db2ilist That will let you know if you created one or not. If not, you will need to create one with &lt;db2 install path&gt;/instance/db2icrt. Check the install docs for more information on this step. Hope it helps! Pete
handboy_jackie
2
user's latest post:
Trouble in installing db2_v9 in...
Published (2009-11-07 05:21:00)
未命名.JPG (47.7 KB)
 

Latest active threads on DB2 for Linux, UNIX, and Windows ::

developerWorks : Information Management Forums
Started 3 days, 10 hours ago (2009-11-12 23:41:00)  by Saurabh.Jain
I think in 9.7, you have row_num() function. I've also replied to this kind of query here https://www.ibm.com/developerworks/forums/thread.j spa?messageID=14279553&#14279553 and here http://www.ibm.com/developerworks/forums/thread.js pa?messageID=14278921
Thread:  Show this thread (3 posts)   Thread info: Data in Batches Size: 350 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Data in Batches :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 3 days, 3 hours ago (2009-11-13 06:31:00)  by vinni
Hi, Could you please paste the steps you are trying to repro this issue. On my machine it works fine. Thanks
Thread:  Show this thread (6 posts)   Thread info: Errors when compiling the sample stored procedures Size: 223 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Errors when compiling the sample stored procedures :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 11 months ago (2008-12-18 07:23:00)  by bchavda
Event Viewer shows Application Error: Faulting application db2instsel.exe, version 9.5.300.414, faulting module db2instsel.exe, version 9.5.300.414, fault address 0x0001749b.
Thread:  Show this thread (3 posts)   Thread info: V9.5 FP3 Windows client - Error installing Size: 267 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: V9.5 FP3 Windows client - Error installing :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 4 days, 1 hour ago (2009-11-12 08:52:00)  by Salvatore.Vacca
I'm not sure to have understood your question, anyway, to insert 'line feed' you can concatenate the hexadecimal value as following: insert into testing (id,info) values(1,'file1=/opt/test1/conf1;' || x'0A' || 'file1=/opt/test1/conf1;') I hope this can help regards Salvatore Vacca
Thread:  Show this thread (4 posts)   Thread info: "\n" and ';' in insert statements Size: 403 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: "" and ';' in insert statements :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 5 days, 17 hours ago (2009-11-10 17:03:00)  by nivanov1
There are a couple of things that could be wrong. First, for a domain user DB2 tries to list the user's groups in the domain by default. To override this behaviour set the registry variable: db2set -g DB2_GRP_LOOKUP=local Second, for DB2 to be able to authenticate the user, the account under which it is running (the one that the DB2 service uses to log in) should be allowed to ...
Thread:  Show this thread (3 posts)   Thread info: Unable to create/drop database with Windows ad account Size: 498 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Unable to create/drop database with Windows ad account :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 3 days, 18 hours ago (2009-11-12 15:21:00)  by Tonkuma
What query did you run?
Thread:  Show this thread (3 posts)   Thread info: query error Size: 101 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: query error :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
developerWorks : Information Management Forums
Started 4 days, 21 hours ago (2009-11-11 12:17:00)  by Salvatore.Vacca
To use audit with DB2 v9 or more, I'd like to suggest you to see my previous post on the topic http://www.ibm.com/developerworks/forums/thread.j spa?messageID=14158701&#14158701 I hope this can help regards Salvatore Vacca
Thread:  Show this thread (2 posts)   Thread info: db2audit prune all option in DB2 v9.7 Size: 347 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: db2audit prune all option in DB2 v9.7 :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
 

Hot threads for last week on DB2 for Linux, UNIX, and Windows ::

Started 3 days, 3 hours ago (2009-11-13 06:31:00)  by vinni
Hi, Could you please paste the steps you are trying to repro this issue. On my machine it works fine. Thanks
Thread:  Show this thread (6 posts)   Thread info: Errors when compiling the sample stored procedures Size: 223 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Errors when compiling the sample stored procedures :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 4 days, 1 hour ago (2009-11-12 08:52:00)  by Salvatore.Vacca
I'm not sure to have understood your question, anyway, to insert 'line feed' you can concatenate the hexadecimal value as following: insert into testing (id,info) values(1,'file1=/opt/test1/conf1;' || x'0A' || 'file1=/opt/test1/conf1;') I hope this can help regards Salvatore Vacca
Thread:  Show this thread (4 posts)   Thread info: "\n" and ';' in insert statements Size: 403 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: "" and ';' in insert statements :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Re: query error - 3 new posts
Started 3 days, 18 hours ago (2009-11-12 15:21:00)  by Tonkuma
What query did you run?
Thread:  Show this thread (3 posts)   Thread info: query error Size: 101 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: query error :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 5 days, 17 hours ago (2009-11-10 17:03:00)  by nivanov1
There are a couple of things that could be wrong. First, for a domain user DB2 tries to list the user's groups in the domain by default. To override this behaviour set the registry variable: db2set -g DB2_GRP_LOOKUP=local Second, for DB2 to be able to authenticate the user, the account under which it is running (the one that the DB2 service uses to log in) should be allowed to ...
Thread:  Show this thread (3 posts)   Thread info: Unable to create/drop database with Windows ad account Size: 498 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Unable to create/drop database with Windows ad account :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Re: Data in Batches - 3 new posts
Started 3 days, 10 hours ago (2009-11-12 23:41:00)  by Saurabh.Jain
I think in 9.7, you have row_num() function. I've also replied to this kind of query here https://www.ibm.com/developerworks/forums/thread.j spa?messageID=14279553&#14279553 and here http://www.ibm.com/developerworks/forums/thread.js pa?messageID=14278921
Thread:  Show this thread (3 posts)   Thread info: Data in Batches Size: 350 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Data in Batches :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 1 week, 2 days ago (2009-11-07 05:21:00)  by handboy_jackie
Back to Thread List
Thread:  Show this thread (2 posts)   Thread info: Trouble in installing db2_v9 in UbuntuV9 Size: 720 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Trouble in installing db2_v9 in UbuntuV9 :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 4 months, 3 weeks ago (2009-06-22 14:52:00)  by LeoPetraz
Correct DB2 Enterprise Trial link: http://tinyurl.com/ese970
Thread:  Show this thread (6 posts)   Thread info: DB2 9.7 available for download Size: 188 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: DB2 9.7 available for download :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 6 days, 22 hours ago (2009-11-09 11:48:00)  by NicoleF
Hello, No, the Windows server should not need to be rebooted. If you are seeing strange behavior with your services starting up, etc, a reboot would not hurt of course, but it is not a requirement. Please see the below link for information on applying fixpaks in Windows env's for DB2 v9.1. http://publib.boulder.ibm.com/infocenter/db2luw/v 9/index.jsp?topic=/com.ibm.db2....
Thread:  Show this thread (3 posts)   Thread info: db2 v9.1 fixpacks Size: 525 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: db2 v9.1 fixpacks :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"
Started 4 days, 21 hours ago (2009-11-11 12:17:00)  by Salvatore.Vacca
To use audit with DB2 v9 or more, I'd like to suggest you to see my previous post on the topic http://www.ibm.com/developerworks/forums/thread.j spa?messageID=14158701&#14158701 I hope this can help regards Salvatore Vacca
Thread:  Show this thread (2 posts)   Thread info: db2audit prune all option in DB2 v9.7 Size: 347 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: db2audit prune all option in DB2 v9.7 :: DB2 for Linux, UNIX, and Windows
 :: developerWorks : Information Management Forums"

This page was found by:   SQL2428N  db2 SQL2428N  SQL2428N The BACKUP did not complete because one or more of the requested log