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