Bytes > topic > db2 > answers

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

1. Create db2 table directly by importing flat file without prior db2 table existing
2. Getting Error sql0338n
3. How to get the stored procedure information?
4. hw to get the stored procedure information?
5. Db2cmd error
6. MQT with MQT
7. Performance Problem with Order by Clause in DB2
8. BAckup online with include logs fails !!!
9. How to write a stored procedure?
10. locks, transactions and stored procedures
11. Return union result in one row?
12. SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?
13. Journals in DB2 Server Edition???
14. Migrate DB2 database from Solaris to Red Hat Linux
15. How to calculate size of partition in DB2
16. MQT in DB2 V9.1
17. Problem in fetching procedure text
18. Problem with cursors
19. what is bufferpool in db2?
20. Urgent - DB2 Function
21. i am getting error of SQL0811N in db2 stored procedure. please help its urgent!!!
22. MERGE STATEMENT IN UDB vs z/OS
23. db2 user account deleted accidentally
24. Using LIKE to compare input to column
25. how to load a Db2 table from a compressed file which is an discarded output of REORG
26. error in Stored procedure while using cursor
27. A long string as a Input parameter in procedure
28. List of ALTER Commands which needs REORG to be issued
29. Improving a SQL statement
30. Data export from db2
31. How to connect db2 to java
32. Sort table names by foreign key dependencies in a schema/Database
33. From Oracle to db2 Federation - db2 "crash"
34. Problems querying tables in federated database
35. How to insert X rows into a table from a Select clause?
36. Difference in record counts
37. DB2 cast issue in UPDATE with parameter marker
38. -802 error for count(*) query for a DB2 table
39. Viewing the SQL behind a View in 9.5
40. Database exception while running a batch program on Db2 V8.
41. Which function has TOTAL equivalent to Oracle's TO_CHAR?
42. Connecting to DB2 v7.1 from .NET ?
43. Updating only the year in a date
44. Alter an index in DB2
45. Compare multiple result sets
46. How to connect from DB2 V7.1 to DB2 V9.5 ?
47. How can i store the value returned by sql statement in a variable.
48. Merging Two Triggers
49. How to have multiple statements in one query using iDB2Command in .Net
50. Migrating database from DB2 V8.1 to 8.2
51. db2 index reorg status monitoring
52. Db2 9.5 behaviour in Solaris 10
53. Questions with Archival logging for HADR Setup
54. Few Questions with HADR - 1
55. how to detect unavailable tables?
56. Fetch command in cursor is very slow....
57. Struggling with db2 and ASP app -- Calling a stored procedure
58. db2 v9.1 UDF in C, Windows platform
59. The command contains illegal characters or keywords (It does?)
60. Both my application and reorg is slow...
61. No one can answer this question
62. convert 'Apr 19 20:00:03 CDT 2009' string to date
63. Problem with Update Query in db2 9.5
64. Connecting to Mainframes DB using a .NET interface
65. Web Form to Database
66. Set Null Using Java
67. DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's
68. db2move issue with as400 iSeries library
69. Incorrect "union all" results
70. 2 linked inserts in one statement
71. DB2 table design and performance considerations
72. Difference Between DB2 zOS and DB2 UDB
73. DB2 integer to Varchar autoconversion in Update
74. How to Transmission of Large data accros network?
75. Help required on using FILTER USING in CREATE FUNCTION
76. Loading tables from USS on Z/OS
77. DB2 on delete cascade is not working
78. Single Tablespace or Separate Tablespaces
79. retrieve all table names from DB2
80. Stored procedure, function, very dynamic SQL and casting
81. problem with db2 installation
82. Trigger Problem
83. Migrate db2 express to iseries
84. db2 cross platform restore
85. DB2 Join result columns are unnamed due to different column names used in subqueries
86. Calling a UDF
87. Row Locking
88. How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
89. help: a speech interface for information retrieval using a .db2 file
90. same fenced user for different instances with different versions of db2
91. Larger DB2 spaces
92. remove newline character from field in exported table
93. Syscat.triggers valid column
94. DB2 Cpu Usage
95. DB2 TableSpace Usage Actual Size vx Allocated Size
96. Asyncronously accesss data using JDBC from DB2 database
97. sending alerts to users
98. Get diagnostics
99. How to recovery a dropped table?
100. db2 upgrade to v8.2
101. DB2 AIX Admin tools ??
102. Is Replication center v8.1 compatible with DB2 v7 Z/OS ?
103. restore database
104. plz suggest reg. cursors
105. plz help- query related to DB2
106. Using a DB2 User Defined Function
107. makefile
108. Updating an indexed column with the same existing value
109. SQL0104 on Update with Fetch
110. Use of OLAP function
111. How do I change Instance in DB2
112. Catalog Local windows DB2 database on AIX machine
113. MS-SQL queries to DB2 conversion
114. Should system temporary tablespaces generally be on automaticstorage?
115. u just click u get some dollars
116. SQL0284N error
117. how can i generate a unique table name at runtime from db2?
118. How do I concatenate strings from a column into a single row in DB2
119. SQL0206N "O.$COID" is not valid in the context where it is used.
120. Online reorg & log full condition
121. SQL Doubt
122. Trigger: After Delete ... for each row behaviour
123. Views and union...
124. passing input paramter of type list
125. diag.log.sav
126. Can we create a sample database on the app dev client
127. Explain of update-statement without commit
128. What the problem with VARCHAR_FORMAT?!?!?!
129. Confused about memory parameters
130. DB2 triggers & Cascading deletes
131. JOIN between 2 tables. No foreign key, just ranges
132. Online backup locking out processes...........
133. UDB Stored Procedure
134. Prepared statement too long
135. Sustain Business with Regular Audits
136. DB2 and CIO DIO on AIX
137. Lock Table and auto commit
138. A blog to lift the fog on Dataphor
139. any documents for 32 bit and 64 bit stored procedure conversion ?
140. Re: SIGNAL ON DELETE AND CAPTURE
141. DB2 DBA required in Vancouver, BC (Contract)
142. Re: SIGNAL ON DELETE AND CAPTURE
143. Java or .NET interpreter startup or communication failed, reason code "2"
144. No access to the SNAPDYN_SQL view
145. Stored procedure Slo
146. How to "LOAD COPY NO" without backup ?
147. DB2 PHP connection issue
148. Query doing table scan when added simple predicates
149. new dba blog
150. Is this an Invalid option? | db2pd -apinfo
151. parallel insertion into a table in DB2
152. NOT ENFORCED RI - what optimization opportunities are missed?
153. DB2 Career
154. SQL0746N: Routine violated nested SQL statement rules when attemptingto perform operation "MODIFY" on table
155. Stored Procedure has no access on a remote file
156. Please review this Explain plan output - need help
157. Uniqueness checking overhead
158. setting optimization level in stored procedure
159. SQL Error
160. db2diag -g db=DBNAME,instance=instname
161. FLUSH PACKAGE CACHE DYNAMIC
162. Load performance on AIX w/ SAN
163. Last access time for index
164. SQL30081N error
165. Multiple databases in one project
166. dsn1copy uses dynamic allocation for multiple pieces
167. Error using old table() in UDF
168. Unable to restore DB2 Database on Linux
169. "WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token
170. 64 bit encoding in CLOB
171. Problems with a simple Trigger :-(
172. sqlqgRouter_conn_lost_cleanup in db2diag.log
173. How can i modify the following query in DB2
174. Linux + DB2 + php
175. Co-releated Update Statement Tuning
176. Overriding database collation in queries for LIKE operators
177. Find SQL in Stored Procedures
178. Getting rid of kuddb2
179. IBMLDAPauthserver/IBMLDAPgroups, DB2 v. 9.5 ppc-Linux
180. Database creation failing on AIX.
181. Migrate schedules from one instance to another in V9.5
182. runaway sqls
183. DBA question on locating partition to which a specific tablespace page exists
184. SQL PROCEDURE on the iSeries
185. DB2 - forcing a table to cache all data in the buffer pool.
186. What is the syntax for finding the Month(number) in DB2?
187. DB2_USE_ALTERNATE_PAGE_CLEANING and HADR
188. db2 doesn't start on windows2003(update from win2000)
189. After adding a tablespace container: DMS rebalancer is active
190. More DB2 Vista NewBee questions
191. Beginner help needed - error connecting DB2-9.1 with RAD7.0
192. HADR - AIX
193. NewBee Express-C Questions
194. How to debug sqc program
195. Backup with include logs option
196. encoding schema in pcap file
197. Assume a bookshop has database with the following
198. Capacity of "Trial"
199. call a SQL Server 2000 stored procedure from DB2
200. Multibyte data passed from OMVS to DB2 stored procedure gets corrupted.
201. Problem with calculate difference between rows
202. capturing optimization level used for certain sql
203. How to get database size in DB2?
204. index usage?
205. DB2 instances in SDLC
206. Troubles with Start database manager
207. Optimal Method for Getting Max Value
208. Dynamic From Clause To Create View
209. PCML and DEXA
210. Max table or database size?
211. db2 questions
212. V9.5 HADR On AIX
213. how to run a COBOL-IMS-DB2 program
214. stored procedures dependencies
215. Query for selecting NON DUPLICATE ELEMENTS in a table
216. difference in performance in two environments for same sql
217. Re: SQL0104N An unexpected token error
218. difference in performance in two environments for same sql
219. Replication Connect Error
220. DB21034E with triggers
221. dynamic sql - prepare statement
222. db2fmd - instance crash
223. Diff in DB2 versions
224. Unique values in column
225. Update using WITH statement
226. SQL1042C An unexpected system error occurred. SQLSTATE=58004
227. Unicode arguments in posstr(), locate() and LIKE
228. Restore Questions (32 vs 64 bit)
229. DB2 federation problem when reconnecting to a remote federated AS/400
230. How is DB2 tables stored?
231. regarding cics
232. db2stop taking time
233. Merge on LUW 9.5.1 - Not Atomic Continue on SQL Exception
234. Restrictions for SSL on db2 express c luw?
235. DB2 Database Administrator
236. DATABASECAPACITY and SMS tablespaces
237. stored procedure to drop tables
238. Health Monitor Invalid history version in header
239. What happens after new function mode
240. java torque nullable columns
241. Possible to manually mark routine packages as inoperative in DB2LUW?
242. adding nullable columns through torque
243. DataServices World features Universal Services, SOA, WOA and cloudcomputing (San Jose, November 20, 2008)
244. SQL3255 on DB2 v9.1 Win32 with db2move
245. java torque save method exception
246. issue on
247. 9.5 LUW, pointers on running 32 bit client against 64 bit server?
248. Question on SQL-based Administrative Task Scheduler
249. Yielding timeslice
250. db2 stored procedure
251. Get the last day of previous business quarter
252. NO FILE SYSTEM CACHING - Automatic?
253. Sigh, Undocumented error - SQL30082N, RC=22
254. Health Monitor - Manual Backup required...why?
255. confusion about cardinality in explain plan node on compressed table
256. confusion about cardinality in explain plan node on compressed table
257. Procedure performance vs Query
258. Re: MDC vs. cluster index: which to use?
259. backup with multiple targets
260. Add a partition to a table that already has partitions
261. Supress SQL0347 (CTE may contain infite loop)
262. update from select
263. SQL30082N Attempt to establish connection failed with security reason"24" ("USERNAME AND/OR PASSWORD INVALID").
264. Set Encryption password and SQL20143N
265. Yellowfin Enhances Business Intelligence Reporting forTelecommunications
266. CTE is not supported by db2advis
267. PHP5 and DB2 9.5
268. Db2 bind issue
269. query help
270. Detected the death of an EDU. Process was 11.
271. reset monitor switches while capturing snapshots with sql functionsor views
272. DB2 and Websphere MQ transaction coordination
273. db2 database pages
274. Solaris 10 Database bufferpool problem
275. sybase post
276. How to determine the isolation level of incoming queries.
277. Unique Opportunity To Join The Elite Group Of Project ManagementProfessionals
278. Select with odbc_exec (php)
279. calling stored procedure from Perl code
280. Syntax error when creating user mapping in DB2 (Data Federation)
281. actual/estimated cost/cardinality of query plan
282. progress bar for runstat?
283. DDF Security?
284. All about memory
285. HADR Status
286. DB2 low CPU low IO (low insert,low update) why ?
287. DB2advis error
288. please help
289. truncate tables in stored procs?
290. How to Give Operating System Security in db2 if not configured duringinstall ?
291. How to view the special registers in db2
292. DB2 V8 String Parsing Question
293. Migration from SYbase to UDB database
294. Query execution
295. lfd length & pd length
296. Block Comment Confusion ...
297. DB2 - check if product installed on Solaris/AIX/HPUX
298. DSNL013I & DDF, DB2 9.1
299. DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL Procedures
300. Connect to Windows DB2 server from unix
301. DB2 problem, need help
302. REORG INPLACE -964 ERROR
303. INPLACE REORG problem
304. Kernel parameters for db2 v8.2 on Solaris 10
305. DB2 Client Upgrade Questions ....
306. HAVING and WHERE clauses: Performance considerations in SQL
307. how to find middle row of a table?
308. SQL help
309. Try ... Catch
310. Newbie - Partition setup multiple tables
311. received this error message DB21034E running an ALTER Stmt
312. Last DB2 to run on Solaris 8
313. LOAD with COPY
314. query to retrieve middle row of a table
315. Difference between byte[] and blob
316. Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5
317. To Execute DB2 commands on AIX with a user other than instance.
318. Collecting DB2 performance results for my thesis paper
319. Selecting from a Dynamic Table in SQL
320. Just checking
321. Dynamic sql statement called in a stored procedure SP
322. Please explain query intervals output
323. On-line file backups
324. Variables in SQL???
325. outer join table filtering
326. Row_number() over() not working in SPUFI
327. SqlException Unsupported ccsid, encoding, or locale: "Cp037"
328. why is NULLID.SYSSH200 executing so many times
329. Leading Zeros
330. DB2LOOK Privileges
331. multiple databases in one instance
332. ******GOD OF GIFTS 4 U*********
333. IF Exists Bad Parser
334. Re: Include all columns in an unique index
335. shell script to extract rows from table
336. Re: DB2 Container behaviour on EMC DMX 3 San.
337. using setAutoCommit(false) in DB2 and MSSQL
338. db2 V9.5 SQL1084C
339. Re: Include all columns in an unique index
340. Why is my static SQL dramatically faster than dynamic?
341. IXF Column Descriptor Record
342. Re: Include all columns in an unique index
343. Db2 v9.5 - Undefined Symbol while creating an instance
344. Merge statement: Index on source table
345. DASCRT Command failed.
346. Multiplexed Connection
347. Re: flush package cache dynamic executed from client.
348. Self tuning bufferpool
349. Self tuning bufferpool
350. regarding RAM size and db parameter
351. Empty Table
352. Help with query on sparse timeseries data
353. Net Search Extender Throws Confusing Error
354. Prepare Statement in DB2
355. Ondemand
356. Dropping indexes on a partitioned table
357. Rows in a DB2 table..
358. Requirement - Database Architect - State of Oregon - 6 months
359. Merge Into using 'With UR'
360. IBatis DB2
361. DB2 error in DB2 control center
362. Changing the DB2 Interface Language under Windows
363. Does V8 of DB2 zOS supports
364. db2 tablespace restore
365. db2 table space restore
366. Interview Type Question
367. Time related question (Subtime)
368. Mass Updation of Records
369. Rows in IXF file
370. Need example for accessing Resultsets from COBOL DB2 Stored procedures from Java
371. Deletion from a large table (with two child tables) takes more than an hour
372. Yellowfin says Java the smart option for Business Intelligence
373. Clob variables in stored procedures and SQL10003C
374. Question Regarding Parameters for DB2 COBOL Stored Procedure
375. Using load/import with global temporary tables
376. how to force bind option for JDBC in db2?
377. DB2 equivalent to this Sybase syntax
378. DB2 Bulk Load via Java/JDBC
379. Db2 Explain weird results
380. Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
381. REORG REPLICATED TABLE
382. retrieving information from 2 tables
383. blob and clob
384. MQT cannot be used for queries with parameter markers?
385. Project Management 2.0 !
386. Clob
387. Primary Key error wrong number of qualifiers
388. DB2 9.5 equivilent of alternate fixpack
389. how to ensuring MQT freshness
390. SQL0101N The statement is too long or too complex. SQLSTATE=54001
391. DB2 UDB LUW full time positions in California
392. V9 client accessing V7.2 server
393. SQL27984W - Some information has not been saved (import create mode)
394. Delete and concurrency problems
395. DB2 Consultants required at Bangalore
396. DB2 Consultants required at Bangalore
397. Need help with dayofweek function
398. Temp table issue
399. Temporary table issue
400. Problem using/naming subquery
401. Query about DB2 unload
402. DB2 update using CTE
403. db2 hash functions
404. Use of inequality in where clause
405. query on query plan and MQT
406. Type 3 driver definitely dead in DB2 V9?
407. Need help to replace OLAP
408. Specifying statement delimiter in DB2 Universal JDBC Driver
409. Can JOIN be used as alternative to NOT EXIST
410. db2gcf -k, Why is it used?
411. NEWLOGPATH and folder NODE000
412. DB2 Host variables - PL/1 locator reference
413. Best way to create a table
414. load and generatedoverride
415. migration of db2
416. Help with rollforward through most current active logs
417. DB2 hangs on USEREXIT failure.
418. Archival logging and USEREXIT BEHAVIOR.
419. Statistics on temporary tables?
420. why this 2-column index not used
421. Enforcing one-to-many relationship in an existing join table
422. Property for setting codepage or codeset in JDBC
423. LUW generation 8 -> 9.1 or 9.5 experiences?
424. Sybase IQ to DB2 for LUW migration helps
425. Can constraint replace a trigger?
426. lowering HWM
427. Unique db id required for n-tier websphere application
428. DB2 dynamci Query execution ??
429. Viewing table constraints
430. db2 design advisor giving error SQL0180N The syntax of stringrepresentation of a datetime value is incorrect
431. DB2 does not complain(or warn) about data loss
432. How to form a date value from decimal or smallint values
433. IDUG North America 2009 - Denver (May 11-15, 2009) - Call for
434. QUESTION: Task Center job won't complete
435. Select and Inserting into two different databases
436. Re: How to fix duplicate SSN without table recreration?
437. Potential abolition of leap seconds - USNO impact survey
438. How to learn IBM-DB2
439. Can we create UDF using View instead of table
440. host variables in cobol
441. what is DB2INSTDEF
442. default timestamp value and performance
443. DB2 taking a long time to start archiving logs
444. SQLerror code
445. Problem in getting the columns name in export command
446. SQLCACHE_SNAPSHOT function returns no records.
447. db2ckpwd not running under root
448. Re: select in a stored procedure call
449. question: multiple row insert vs. merge
450. deleting backups with db2adutl and meaning of keep parameter
451. Generate 'Create database' statement
452. set write suspend on database takes multiple hours
453. Location Intelligence where to from here?
454. How calculate date/time difference in DB2
455. Join two identically structured views
456. Sql Stored Procedure
457. Help: UPDATE FIELD WHERE CONDITION BASED ON SELECT QUERY FROM MULTIPLE TABLES.
458. Filter Factors when using Parameter markers?
459. How to implement insensitive scroll cursor
460. isolation levels and locks
461. Array Insert x db2Import
462. what wrong with my UDF use?
463. DB2 partial matching in COBOL
464. How to prevent duplicate insertion without locking the entire table?
465. DB2 Response File Installation
466. Exporting large data from QMF to mainframe dataset
467. read only database
468. Re: Reg: Owner for Declared Global Temporary tables
469. remove DB2 Connect Server ?
470. FP2 Vista cannot configure default instance
471. Do you know how I can monitor z/os DB2 activity from a unix/windowsmachine?
472. Problem DB2 9.5 connection to Iseries
473. DB2 RTCL for linux
474. Db2 Dba
475. ONLINE RESOURCE FOR HELP DESK SOFTWARE
476. Create Database with RESTRICTIVE Option
477. Load syntax help!!!!
478. Software Problem resolution
479. Query plan / table partitioning
480. Strange 911 error
481. Re: Statements with 2MB size
482. Large number of reads on sysibm.sysuserauth.
483. Re: select rows where
484. soliddb db2 sql conformance?
485. dumps for db2 certification no 730 and 731
486. What is DB2 agent ???
487. How to move tables into different tablespace ?
488. DPF on 9.5
489. Scalar sub query in db2
490. Multible inserts in one Trigger - return code -206
491. Multiple tables or single table in one tablespace ?
492. How to get top 1000 rows
493. Temporary Table
494. LDAP authentication
495. problem in creating a db
496. sysproc.snapshot_tbreorg: What does rergo_status value '4' means ?
497. Please Help: Insert generating -803 in Trigger
498. Re: Recursive Data and Stored Procedure in DB2
499. Runstats / OLTP environment
500. db2 700 exam
501. DB2 Best Practices
502. SQL0101N The statement is too long or too complex.
503. tablespace queisced after load fail in partioned db
504. Automate Log shipping
505. DB2 Migrate to Oracle
506. How to replaces 1 with corresponding position
507. Project Management Knowledge Base !
508. Dynamic SQL
509. how to get db2 lock waits details
510. SQL query help
511. Verify attribute content
512. Range partition overlap
513. SQL30081N error while connecting to a DB2 ver. 7.2 Database
514. connecting servers for playing with HADR
515. SQL0440 error on delete statement
516. DB2MOVE
517. Control Center extension
518. Removing a newline character from a VARCHAR
519. Moving tables between tablespaces
520. Regarding concurrency MERGE x UPDATE
521. Date function help subtracting dates
522. recursive query - donot repeat the sub path that has already beendiscovered in the tree
523. Sybase to DB2 Migration
524. DB2 Stored Procedure Refresh
525. DB2 Stored Procedure Refresh
526. installing db2 connect product on a machine with db2 ese alreadyinstalled
527. How to access DB2 using DataSource?
528. Embedded SQL returning uncatchable error - Procedure/Trigger
529. DB2 on AIX - Authenticate against Active Directory
530. DB2 UDB Objects Dependent on UDF
531. Max Lehgth Of A Row In Db2
532. Db2 loading from Tab delimited Txt file
533. Database release level
534. Max Length Of Varchar
535. How to Write this SQL Statement?
536. UPDATE CURRENT OF CURSOR
537. SUM function with conditions (>) or (<)
538. Can't view tables through Control Center
539. db2 get snapshot for dynamic sql output question
540. Problem with Db2 Export Command
541. matching criteris for a 10-digit number
542. DB2 backup Valid or Corrupted
543. DB2 Web Tools - Error code 101
544. First iteration of stored procedure is slow.
545. Having problem restoring incremental backup
546. db2 procedure in solaris
547. Alternate server for the db2 connect --fail over
548. DB2 V9.5 FP2 release date
549. ErrorCode
550. Re: SQL 2008 published - Highlights