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