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