View Full Version : db2 answers


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

  1. Occasional -30082 after an SQL1024
  2. DISTINCT and ORDER BY
  3. How to start the DAS in Linux
  4. Problem with Modifing MQT
  5. generate_unique primary key
  6. Syntax issue: URGENT
  7. SQL30082N reason 36
  8. How to expire DB2 backups in TSM ????
  9. V9 client unable to connect to V7 server!
  10. Tablequeue buffers overflow
  11. "Time waited for prefetch (ms)" very high
  12. XML Extender - CCSID to UTF-8 help required
  13. Locking problem
  14. Query tunning
  15. hi
  16. Tablespace reovery
  17. How to match a Java SQL Exception to the SQL error message
  18. PATHCH2="15" is ignored?
  19. Express C forum dead?
  20. How to backdown from DB2 v8 Fixpak 12 to Fixpak 10
  21. db2_install error
  22. DB2 Connection Problem
  23. IRC Forum for Discussing DB2
  24. Express-C (Linux 32-bit) : CREATE DATABASE fails
  25. DB2 9 Express C Functionality
  26. Restore DB2 from DB2 Legato Network Server
  27. List of users connected to DB2 UDB database
  28. what is the lightest-weight client query/statement?
  29. WebSphere Federation Server (v9)
  30. Uncommited Insert/Upd/Del Count
  31. DB2 9 for LUW is electronic GA
  32. Db2 in non-interactive mode
  33. INHERIT SPECIAL REGISTERS
  34. Command to get the size of DB2 database
  35. Federated Server
  36. ICREM BINDS
  37. DB2 audit
  38. query pre-processing
  39. Silly query question
  40. How to run LOAD or IMPORT from Java
  41. Can I see the rows deleted by LOAD
  42. Recovery tool for DB2E v8.2 on WinCE?
  43. HADR takeover by force during peer state - why does this end up with split brain ?
  44. TABLESPACE DROP AND REDIRECT RESTORE
  45. Table partitioning in V8.2
  46. DPF Question
  47. sql stored procedure questions
  48. SQL 0440N SQLPROCEDURECOLS
  49. db2uext2.cdisk
  50. Question about tablespace and container design
  51. RI to be enforced in tables containing data
  52. Cognos Cube and DB2 "UOW Waiting"
  53. Cognos Cube with DB2 "UOW Waiting" status
  54. Aggregate UDFs
  55. SQL_DATA_ACCESS set to 'M' in SYSROUTINES even though only selects
  56. Finding dependencies in stored procedures
  57. Index Optimization Question
  58. Replication - limit of 200 tables in subscription set
  59. same trigger problem
  60. SQL0670N creating table with 250 columns
  61. Migration / DEmigration
  62. Index tablespace
  63. Best practice
  64. Unable to Enable the DB2 Image Extender
  65. How to ALTER a table using the ALTOBJ procedure
  66. database Share Memory Limit (2 GB ) in a Instance is total of all Db shared memory of all databases in a single Instance!!
  67. migration db2
  68. List History Backup
  69. Db2DAS
  70. Bizarre Crash Recovery
  71. Query for file names like SC*
  72. New Problem Determination Mastery Exam in the works?
  73. MON_HEAP_SZ
  74. DB2 Personal Developer Edition and Spatial Extender
  75. unable to start db2 admin server
  76. db2 Backup using TSM
  77. Procedure Dependencies and Temporary Tables
  78. DB2 Application Dev Client (Fix Pack 10) on Windows 2000
  79. how to get agent id
  80. HOWTO: Make DDL changes?
  81. unique generated numbers
  82. Update Syntax SQL
  83. db2gov
  84. Db2 backup List
  85. DB2 and Java
  86. Help for a SQL Query statement: group by
  87. db2 connect to "psftggl"
  88. DB migraton failed from DB2 V7 FP13 to DB2 V8FP7
  89. xml Extender... cannot enable a column!!
  90. Referential integrity in DW necessary??
  91. DB2: Find most recent rows?
  92. Trigger design issues
  93. Micro-pump is cool idea for future computer chips
  94. db2Load API in C#
  95. Database requirements
  96. Able to Create a Procedure in DB2 V8.1 But Unable to Run it using CALL statement
  97. SQL30082N Attempt to establish connection failed with security reason "24"
  98. EXPLAIN and Global Temporary Tables
  99. bulk load very slow
  100. BIND, DYNAMICRULES and SQL Procedures
  101. What the heck are node names and aliases for?
  102. COMMIT statements in a stored procedure
  103. Speeding up Full Online Backups
  104. Should db2 allow this table to be created
  105. Something like base64_encode ...
  106. How to license DB2 in P570 server
  107. restore - mirrorlogpath problem
  108. Select Query - Looking for a better query
  109. Performance questions DB2 UDB 8.1.9 Linux Redux
  110. iSeries DB2 Delete Statement Question
  111. db2 v8.1 config question.
  112. User Exit Program
  113. Querying for Third Shift
  114. Accessing remote database via SQL
  115. Error SQL0901N without any Reasoncode
  116. Applying a patch
  117. DB2 Certifications
  118. DB2 SQL insert question
  119. db2 authorities very vague
  120. Performance questions DB2 UDB 8.1.9 Linux
  121. High Performance DPF INSERT's
  122. Emergency Help
  123. Error in replication log
  124. getting -805 for SYSLH203
  125. PlZ HELP
  126. Urgent Query
  127. Tablespace - mysteriously lost pages.
  128. INDEX setup on surrogate key
  129. SQL procedure tracing
  130. Error in executing SYSPROC.ALTOBJ procedure
  131. db2diag.log
  132. Migrating DB2 UDB on Solaris 8 to DB2 UDB on Z/OS 7
  133. Weird message in db2diag.log
  134. Trace,....
  135. creating a instance
  136. Variables in SP do not compare as equal when both are NULL
  137. DB2 VSE/JDBC
  138. SQL0440 - Routine XXXX in *N not found with specified parameters.
  139. set current explain mode recommend indexes
  140. SQL Optimization
  141. Using Foreign Key To Ref A Unique Index
  142. RESTORE PROBLEM FROM DB2 V8.2 TO V9
  143. db2 listener
  144. Dropping Nicknames
  145. Decompose "leveled" XML to to one single PF ("flattened")
  146. FP12 problem ?
  147. Trees, recursion, and grouping
  148. How to look up a range
  149. Could I use a host variable for replacing the table name in SQC program?
  150. how to increase char(35) to char(100)
  151. DROP TABLE, VIEW, ... only IF EXISTS
  152. SQL30081N
  153. Internal Catalog Cache Lock
  154. Loadrunner, Winrunner and Software Testing Resource Hub !
  155. COMPRESS .. & VALUES COMPRESSION change request: RFC.
  156. Setting env variable in DB2 env
  157. Urgent Positions with an MNC in Noida, for DB2 Admin
  158. The good old quest, - How many disk space the table occupies? - stillinsoluble?
  159. REORG TABLESPACE
  160. LOAD & IMPORT results in different disk space, occupied by a table: why?
  161. Storing documents in db2
  162. ISNUMERIC by TOKUNAGA
  163. clean up old log files
  164. Help with db2move
  165. Table space error : Create Table DDL
  166. [DB2/AS 400] no available conversion for the source code page "819" ...
  167. error upgrading from DB2 7.2 to DB2 8.2
  168. How to drop an index named as "XPKsp_prj_stk_ord_"?
  169. Setting Performance Benchmarks
  170. snapshot tbsp table functions via jdbc
  171. Storing Objects in DB2
  172. db2 V7.2 trap after FP5
  173. Announcing Yellowfin Version 2.5 upgrade release for DB2 based users.
  174. Redirected Restore
  175. Business rules
  176. Reorg Not Reclaiming Anticipated Space
  177. IDUG 2006 - Europe Conference, 2-6 October in Vienna, Austria
  178. How Do You DO This in DB2
  179. remote connection
  180. Connecting to DB2 running on Linux
  181. Locks
  182. Backup/Restore from one tablespace ot another tablespace in the same database
  183. Certificate 700 (DB2 Familly Fundamentals)
  184. Need guidance on DB2
  185. displaying message from triggers
  186. Error while connecting to DB2 Z/OS from DataStage
  187. UDF
  188. db2_all help
  189. DB2 UDB API SQLSetConnectAttr(hdbc,SQL_ATTR_CONNECT_NODE,node, SQL_NTS)
  190. DB2 Latest Fix Pack
  191. How do I format a DOUBLE?
  192. Ulimit setting for a 32Bit DB2 on 64 Bit AIX
  193. db2client + isolation level
  194. Start hadr primary db failed with SQL1768N, reason code 7.
  195. Shell script help
  196. unique constraint and unique index
  197. event monitoring
  198. UDF error
  199. Event ID: 7031
  200. Assign multiple variables from select statement in Procedure
  201. Tablespace containers question?
  202. how to switch back after rerouting to alternative server
  203. Index rebuilt - Time Estimation
  204. Unable to connect to the DB
  205. Initializing Tapes when using multiple tapes
  206. Dynamic SQL within Procedure - String Continuation/Builder
  207. DB2 migration issue from AIX to Linux
  208. How to group date periods together ?
  209. DB2 migration issue from AIX to Linux
  210. BLOB
  211. Optimize UDF speed
  212. SQL30082N with reason "19"
  213. Single Quote
  214. Oracle's SPOOL equivalent
  215. db2sysc consume a lot of memory
  216. DB2 v8.1 Z/OS - What catalog table are SQL Stored Prcedures saved in ?
  217. how to stop new applicaitons from connecting to the databases?
  218. DB Backup to tape on Windows NT Server
  219. Designing tablespaces with a SAN in mind
  220. Can connect to one DB but not another on same server??
  221. DB2 Statement Cache
  222. Slow insert/logging performance
  223. import issue
  224. Remote Detection of IBM DB2 Version?
  225. connecting to a db
  226. CHAR datatype issue
  227. Installing FixPak
  228. diaglog size too big
  229. VARCHAR vs. LONG VARCHAR
  230. DB2 Beginner.
  231. SNAPSHOT_LOCK Errors
  232. Federated Access - DB2 to SQLServer using unixODBC driver
  233. Systables lock during REFRESH TABLE causing issues
  234. DB2 7.2 client and 8.2 server?
  235. Searching View with LIKE predicate
  236. db2 migration problem
  237. What is logged for insert on identity column
  238. Db2 mirror tables
  239. DB2 SQL1224N Error on Windows 2003
  240. db2 & perl
  241. A recasing UDF
  242. COMMIT and DGTTs
  243. Backup and OS Swapping
  244. Backup and OS Swapping
  245. db2look
  246. No remote connections available
  247. Impact of Overflows and Page Reorgs
  248. DB2 EE (or Connect) and iSeries Scrollable cursor problem
  249. Query on indexes for performance tuning
  250. Not Logging
  251. Parameter marker in Select
  252. decomposing/composing XML with only SPs, without code, possible?
  253. SQL query
  254. Variable response time from db2 udb 8.1.9 linux rh 2.3
  255. user list
  256. error when inserting xml into database - string literal too long
  257. error when inserting xml into database - string literal too long
  258. How Can Inclusion/Exclusion of Columns Affect Number Rows Returned?
  259. db2diag.log error
  260. Buffer Pools
  261. WII Federated Data Server on zSeries?
  262. DB2 restores after unrecoverable load in single and mulit-partitioned DB
  263. DB2 restores after unrecoverable load in single and mulit-partitioned DB
  264. multiple db2fm processes and a huge table with a BLOB field?
  265. DB size
  266. table with BLOB impact database performance?
  267. SQL1042C when doing dascrt
  268. Online Backup
  269. DB2 Features: Threads
  270. Usage of TYPE in DB2
  271. Timestamp issue under heavy load
  272. HADR
  273. Command to Display Curernt SQL for a Job
  274. A subtle error in error message parsing db2 udb v8.1.9
  275. Question: Tablespace recovery without logs
  276. Query question
  277. Attach...
  278. Software Testing Resource Hub !
  279. problem with GUI tools
  280. problem with db2iupdt & db2icrt
  281. Null Column on a view
  282. Insert select from SQL table function that modifies sql data
  283. Question on Alias
  284. db2setup on RHEL AS V4 doesn't work
  285. question regarding OR clause with fietch first 1 row only
  286. Java API for tools like db2iList
  287. resolved:DB2 V5.2 on XP SP2
  288. About Discoonection
  289. date/time
  290. Need a 1 min run down of how to log executed SQL statements please
  291. Instance
  292. DB2CLI Crash in multithreading
  293. AS400 and SQL DTS
  294. DB2 Load Utility and Default Values for some columns
  295. db2 load
  296. urgent help me plz
  297. Manually initializing MQT und use Staging table
  298. DB2 Cold backup
  299. Defining additional keys in a joined logical file (DB2/400)
  300. plz help
  301. Strange problem
  302. how to make a chr(0) as the default value of one column?
  303. Quiesce behavior
  304. Rows on the fly and an outer join (use a lateral statement?)
  305. Loading several tables with a single LOAD command
  306. DB2 II for Linux AMD 64 bit
  307. thoughts on regular expression matching
  308. Date function
  309. URGENT :: kill rollng back process? or atleast the status to get the time estimated..
  310. sqlcode 444 sqlstate 42724 while tryint to build a java stoed proc from RAD
  311. OLAP-Functions missing in DB2 Express-C?
  312. event monitor for statements
  313. DB2 DBA: For a CMM 4 An American IT Services Company.
  314. DB2 enabled Datawarehouse Pilot
  315. ADM7508E Database quiesce request has failed. The sqlcode is "-1044"
  316. Current Isolation - Urgent!
  317. upgrade DB2 WSE to ESE
  318. Delete Performance improvement
  319. DB2 control center
  320. DB2 Reporting tools
  321. java.lang.ExceptionInInitializerError: java.lang.ArrayIndexOutOfBoundsException
  322. Error while trying to access db2 mainframe tables
  323. DB2 8 on VMWare problem
  324. How important is KAIO for DB2?
  325. The statement is too long or too complex ?
  326. DB2 support for internal procedures
  327. client userid and odbc
  328. TOOLSDB Missing
  329. DB2 Cube views
  330. Privileges in DB2 v 8.1.9 linux
  331. tools catalog
  332. Help with query
  333. DAS
  334. SP error
  335. Installation probs with DB2 universal Database 8.2
  336. tools catalog
  337. hi
  338. tools catalog
  339. DB2 Scheduler
  340. Question on SUM()
  341. Data Type Comparison
  342. Intelligent miner for data - What's behind ??
  343. DB2 "CONNECT to" or "CONNECT TO"
  344. Federated (information integrator) load from cursor - Oracle date problem
  345. -911 on online incremental or delta backup db2 luw 8.2 on AIX
  346. load utility & identity column -- bug in db2?
  347. Reducing the high water mark for LOB tablespace.
  348. Restore database from v7.2 to v8.2
  349. DB2 Performance problems after REORG
  350. Exam 700 Query--pls help(Urgent)
  351. Run SQL from Windows against AS/400
  352. Becoming URGENT password invalid
  353. problems with concat and parameter markers
  354. Insert taking ages
  355. Access Plan - Operator question
  356. Question on Reorgs
  357. I hope in Serge Rielau
  358. Urgent SQLCODE : 30081 Connection problem
  359. IBM DB2 V9.1 for Linux, UNIX, and Windows delivers hybrid XML/relational data server
  360. V8.2, WINDOWS
  361. CLP Stored Procedure Call differences
  362. password invalid
  363. REORG + INLINE COPY
  364. Drop/Recreate parent table
  365. INSERTIN' INTO TEMPORAL TABLE THE RESULT OF A STORE PROCEDURE
  366. Connecting to Server Problem
  367. Instances
  368. IMPORT ASC
  369. TRIGGERS AND PACKAGES
  370. archive logs regularly for restore on 2. server
  371. Replication on 1 server
  372. CHGQRYA and UDF_TIMEOUT
  373. Shrinking "automatic storage" tablespaces
  374. modifed timestamp of a table
  375. Intelligent miner for data - specific question...
  376. UOW
  377. Help: connecting to db2 udb v8.1.9 linux
  378. 701 DBA certification test - *recommendations*
  379. Star Joins
  380. Impacts on migrating UDB DB2 8.1 to DB2 on Mainframes
  381. sql reason code logging
  382. DIA8533C The system memory limit was reached
  383. alter table in a stored procedure
  384. DB2 TSM backup hung, how to take back control?
  385. plz help
  386. DB2MOVE and generated always columns
  387. UDB 8.1 replication
  388. numeric userids in db2 udb v8.1.9 linux
  389. tablescan instead index scan
  390. Trigger compilation error
  391. sql0901, reason "column number out of range"
  392. SQL challenge in DB2 v8.2 environment
  393. How to convert a stored-proc with one result-set into a table udf
  394. Name too long error when using Load from cursor table
  395. does timerons include the fact of partitioning
  396. Calling Runstats from VBA
  397. Moving from windows to AIX
  398. Authentication
  399. moving tables between schema
  400. hi
  401. Tabelspace Informations
  402. VARBINARY - BINARY
  403. be careful with "application idle time"
  404. Moigration from Oracle 10g to Db2 8.2
  405. DataStage connectivity with DB2 Z/OS
  406. how to grant all tables
  407. make a copy of database to local
  408. Setting a specific Isloation Level at a Database Level
  409. cli load question
  410. xquery error
  411. a strange sql explain
  412. MQT on MQT. Is it possible?
  413. Unable to start HADR reason code 7
  414. translate function
  415. Disabling Constraints in a table
  416. PreparedStatement
  417. Bulk insert from a CSV file to a DB2 file. How?
  418. Stored procedure can't be found
  419. makefile
  420. Wider columns or Deeper Rows?
  421. Spatial Extenders index usage
  422. Install Fixpak 8.1 11 from 8.1 7 connection woes
  423. Parent Child Relationship - System catalog tables
  424. Monthly security Audit Check
  425. DBA Interview Questions
  426. Oracle Server Quick Reference Guide
  427. CREATE TRIGGER ON INSERT
  428. SQLJ.install_jar raises unexpected system error
  429. Problem with executing script under root
  430. Problem with database updation field
  431. 2 Serge Rielau: please, repost bitwise ops implementation (udfbit)
  432. Using a trigger to enforce unique if not null DB2 v8.1.9 linux
  433. cygwin - DB2 on windows
  434. fetching data from db2 using stored procedure
  435. DECLARE/FETCH USING JAVA..(POSITIONED UPDATE)
  436. Issue with executebatch()..Need to know failed records ..not from the exception
  437. CASE AROUND ORDER BY?
  438. VMWare and DB2
  439. Expert tunning Database
  440. Moving Tables from SMS to DMS tablespace
  441. the performance of delete with commitcount routine
  442. seek select statement to fetch rows older than five minutes
  443. select query, return CSV in field
  444. Can I overload stored procedures based on param type?
  445. Can I dynamically reference the table and/or column name in a triggerbody? Special Register?
  446. DB2 AIX: Stored Procedure Dependency Script
  447. Combining rows into a single column
  448. Duplicating a Database using RMAN
  449. SQL0723N, -746 SELECTing from the trigger target
  450. DB2 cursor problems
  451. Unexpected SQL0964C Transaction log full
  452. VIEW and GROUP BY
  453. How to select
  454. Index Utilization at Database level
  455. FETCH operator in SQL plan
  456. Suggest data type
  457. Query Performance / Table Scan.
  458. Does DB2 8.2 Enterprise Edition support IPv6?
  459. problem in creating an instance
  460. What in validates Dynamic SQL Packages in Package Cache ?
  461. DB2 Daily Check Lists
  462. performance issues related to timestamps
  463. Need info about DB2 archiving tools
  464. Need Tech Review of DB2 Backup Chapter for O'Reilly Book
  465. DB2e FIPS 140-2 Compliant????
  466. unable to insert data and time values into table
  467. Online documentation, spelling mistake
  468. SNAPSHOT_TABLE
  469. introduce db2 database
  470. How to get table name from dynamic query ???
  471. About Exit Handler
  472. Running SQL script
  473. Altering a distinct data type
  474. db2look privileges?
  475. Date format
  476. A dream of more functional CLP in v8.3
  477. VB .NET parameters seems to only use order
  478. MF DB2 Stored Procedure Call from SSIS 2005
  479. Bulk Data Transfer
  480. suppressing SQL0100W message
  481. LIKE WITH HOST VARIABLE IN SQL UDF
  482. AS400 to AS400 connection
  483. List applications and Client login ID
  484. Distinct data type
  485. activate not logged initially - bug or feature?
  486. Comparing databases
  487. DB2 Load Varchar for bit data
  488. string data right truncation
  489. Database backup without using 'backup database'
  490. Uncommitted statements?
  491. help needed for displaying a numeric value in a aprticular format..URGENT!!
  492. Application hanging
  493. direct writes
  494. Java Program to list of DBs in DB2 Instance
  495. minpctused
  496. VB .NET parameter has incorrect automatic argument
  497. Unable to start DB2 DAS
  498. Unable to start DB2 DAS
  499. Monitoring Index Reorg
  500. String data right truncation
  501. regarding tablespace PIT recovery.
  502. DB2/CM & SAN
  503. Nodename in catalog?
  504. primary key index?
  505. stored procedure
  506. SQL1042C An unexpected system error occured
  507. DB2 Backup Problem into Samba filesystem
  508. MDC Question
  509. MDC question
  510. Possible DB2 bug in the stored procedure parameters handling.
  511. Database Status Script
  512. Please Help Urgent
  513. Can I create DB2 partitions across multiple flavors of an OS?
  514. Reorgchk Stored Procedure.
  515. restart sequence number
  516. MDC woes
  517. Should I create an index when there's already a composite index?
  518. problem with db2start
  519. V8.2.2 change package-owner without bind?
  520. Multiple session table joins
  521. can i create udf this way ?
  522. List of tables having maximum number of rows
  523. Partition an existing table?
  524. SQLCA error handling in multithreaded environment
  525. Version 9
  526. Comparing tables
  527. Redbook for stored procedures
  528. Client version higher than DB causes error
  529. String Comparison
  530. store strings in different languages (diff. code pages) in one table field
  531. pls help urgent
  532. Definition of a 'Very Large Table'
  533. Design of a table
  534. Can I create an index on a view?
  535. .NET UBB link? (file on web)
  536. Waiting for uncommited rows
  537. What's the best way to move from one DB2 server to another?
  538. Merge problem
  539. IOWAIT/LOCK state when performing Insert into XYZ Select * from XYZ
  540. Guidelines for db server on SAN
  541. runstats within open transaction
  542. Urgent - DB2LOAD API db2LoadInfoIn Struct
  543. working with a stored procedure
  544. Privileges
  545. listener on port 8888 goes down
  546. Can't get primarykey list using ado openschema
  547. Creating Scalar UDF
  548. Connect to IBM DB2 database without installing the DB2 client.
  549. Multiple DB2 Client Versions
  550. Multiple Application Group possible ?