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