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. Move Tablespace Datafile
  2. Combining stored procedure and a select statement - possible?
  3. Declarative XML Processing with XQuery (the future of SQL/XML?)
  4. DB2 Linux and High IO Usage
  5. change tablespace state
  6. CLI connection failed. SQL0902C. A system error (reason code="6029321") occurred.
  7. SOS for long varchar
  8. memory leak, urgent help needed
  9. DB2 8.1 to SP10
  10. DB2 ODBC connection timeout???
  11. send email with db2
  12. Statistics - Table Name, Number of Rows, Number of Columns
  13. db2 and NIS
  14. What is a JOBLOG
  15. Exciting Oracle News :: Oracle DB Worm Code Published :: Oracle PasswordsCrack in Mere Minutes
  16. Linux Runtime Client 7.1
  17. version 7 backup close connections
  18. ImapgePlus mouse support
  19. Migrating from DB2 7.2 to 8.2 Questions
  20. Restore From Offline Backup
  21. SQLJ won't run static....
  22. db2start
  23. database reorg
  24. AYUDA error DB2JAVIT :RC=11
  25. Retrieve last inserted id
  26. HADR incompatibility between the two databases
  27. Diag File Log Entry??
  28. web service leaves thread active
  29. Need Help: Using UDB-Type2-Driver on z/OS DB2 version 7
  30. Need Help, DB2 Crash with Error DIA8301C
  31. db2dasrrm process / monitoring db2 processes
  32. Recover Wndows SAM
  33. DB21061E
  34. "User mapping missing" when accessing FEDERATED nickname
  35. Automatical enable and disable a task center task
  36. Error: SQL0971
  37. Windows Client for db2
  38. DB2 installation problem in the db2 database.
  39. Interested in feedback on DB2 UDB autonomic computing features
  40. SQL0101N and SQL0723N - Recursive Triggers Should Not be Happening
  41. db2 health monitor alert action to run script
  42. How to determine size of a table without running statstics
  43. Attempting to connect with client to remote DB2 instance
  44. WSE 8.1.5 LUW Trap file not written as claimed?
  45. Select the latest record for each ID from a table of historic records
  46. Problems creating database using scripts provided by LMS
  47. To generate Unique id for every SELECT statement
  48. db2 UDB Fixpack 10 on Redhat Enterprise Linux V3
  49. Searching for newline character with posstr
  50. DBD::DB2 $sh->prepare () after FixPack 7 upgrade
  51. why commit while finish a select statment
  52. Install db2 database in the Linux
  53. Foreign constraints DB2 UDB v8.1.7 Linux
  54. I don't understand results
  55. Inserting two spaces into a char(8), DB2 omits a space
  56. Latest Pictures and News from IDUG 2005 Europe Conference
  57. FreeHandle error
  58. Restoring to Different RAID Stripe / Extent Size
  59. User Data Maintenance users
  60. Scripts for HADR failover
  61. Strip titles from varchar string
  62. How to optimize this query in DB2
  63. Edit routine & access path
  64. Trigger structure
  65. ALTER TABLE <TABLE> DROP UNIQUE <INDNAME> doesn't recognize index name!
  66. Complex expression in select list, where, and order by
  67. LOAD vs. IMPORT
  68. Cannot turn on logging for tables with names > 18 chars
  69. Problem of two applications connect to one DB2 server
  70. What is the max length of a trigger name?
  71. Triggers DB2 UDB v8.1.?
  72. Pictures Live from IDUG 2005 Europe Conference
  73. Encryption question - please help
  74. Downloading UDB 8.2 Linux x86-64 PDE
  75. How to decipher a SQLCODE
  76. How to concat several lines into one
  77. LOGARCHMETH1 TSM logarchopt1 db2uext2
  78. Loading a delimited file to a table - new bie question
  79. IBM encryption tool question
  80. JDBC,CLI0109E,VARCHAR(2000) to VARCHAR(4000)
  81. db2 restart required after changing varchar(2000) to varchar(4000)
  82. Problem When Creating Views
  83. Tomcat and DB2
  84. Order By values of a column
  85. Serge......Help me
  86. "Merge Into ..." Trouble
  87. Problem with PreparedStatement and DB2-Function...
  88. Support for Generated columns on iSeries
  89. Long Error Messages in Command Center
  90. General Questions- Need Clearance
  91. Disk Space Calculation for tables
  92. First of each group
  93. remvoing statement event moitors
  94. Searching ODBC-Driver
  95. sending health monitor messages to another application
  96. Indexing Question
  97. Redirected Restore From one server to another Issue, db2advis error.
  98. Sanity check: primary key(a, b) implies index
  99. Query regarding Snapshot API
  100. Help - Migration to DB2
  101. access varchar error
  102. ReadOnly DB? - Improved Performance for Data Mart
  103. DSNTIAUL - Unload a Table that has a Null Ind
  104. Massive sql via WAN
  105. how can I use db2adutl to view TSM info of another physical server
  106. Multi-level Stored Procs and Savepoints
  107. Visit the IDUG Europe Conference Blog for Daily Updates and Conference Information
  108. Problem in DB2 AVI Extender
  109. Problem in DB2 AVI Extender
  110. Net Search Extender for Linux / DEV. ED.
  111. (Visual) Explain for z/OS
  112. Query regarding Performance
  113. db2app.dll could not found Error
  114. Where Am I ?
  115. Where Am I ?
  116. SQL0101N The statement is too long or too complex
  117. A pre-Wilma freebie for the DB2 crowd
  118. Slow connect to local server if VPN active
  119. When are CHECK constraints evakuated?
  120. How to move a database into "global" area?
  121. MERGE and GET DIAGNOSTICS ROW_COUNT
  122. inconsistent rowcount
  123. Comment in an insert statment?
  124. problem with an insert
  125. probelm with temp table
  126. Need Help : Power Builder and DB2
  127. Unable to list tablespaces from Control Center
  128. Capture memory leak
  129. Error SQL0104N on very simple client setup. Help.
  130. Is dual-mode authentication possible under DB2?
  131. HADR disconnected status
  132. Regd: Platinum Fast Unload
  133. DB2WMI and DB2 PE
  134. XML DAD Library List
  135. VBS return value from stored procedure
  136. script to automate table grants like a current user?
  137. Sybase to UDB migration --- help required on joins
  138. Location of Task Center tasks
  139. what query to ask the codepages a DB2 will read?
  140. Fenced user/instance question
  141. Replication - Not replicating deletes
  142. Intel Dual Core Processor and DB2 Licensing
  143. Java interpreter not starting after update to FP10 (testet with JDK 1.4.1. / 1.4.2)
  144. Syntactic sugar for INSERT
  145. Net Search Extender
  146. Have any function in the DB2 database that can generate unique id for each String?
  147. How to UPDATE with joins
  148. DB2
  149. cataloging and rerouting questions
  150. How can I move a table from a schema to another one?
  151. how to get parameter value from dynamic select statement ?
  152. How can I cast a BLOB-value to a VARCHAR-value?
  153. Last Chance to Register Online for IDUG 2005 - Europe - Register Today
  154. Relational Database Usage survey
  155. How can I output my own messages? Can anybody describe the Errorhandling please?
  156. privilege issues
  157. Getting rid of "schema" from DB2 statements in COBOL programs...
  158. SYSADM privilege
  159. null -> not null or vice versa?
  160. Is a statement like this possible: SELECT * FROM (CALL myProcedure)
  161. DBRM Generation
  162. DB2 for AIX Version 2.1.2
  163. case expression with SQL functions
  164. db2 v8 install hangs on windows XP pro
  165. Agents stolen from another application HIGH
  166. DB2 BIND from one database to another
  167. db2 toolsdb
  168. Is there a way to estimate view table size in DB2?
  169. Scaler Function: "Strip"
  170. Incrementing sequences in the same select statement
  171. db2connect and
  172. transitive closure of a graph
  173. Trying to create a heartbeat for db2
  174. Q replication not replicating after an online reorg.
  175. UnInstalling DB@ admin tools....
  176. How to db2level
  177. DB2 SQL Developer Tool
  178. Is there a way to get DB2 z/OS 7.1.1 to cache/reuse statements with jdbc ?
  179. Rebind of Stored Procedures in response to a Table Drop/Create
  180. Where does DB2 UDB v 8 for UNIX write its application log files?
  181. Stumped With Clob data
  182. Can't load library "/usr/lib/libcore.a", because load ENOENT on shared library(s)
  183. Can i write a user defined function in db2 Universal8.2 by the java or other language?
  184. Find my aliases
  185. Logon
  186. DB2 Memory Allocation Error
  187. SQL/PL - Difference between OS/390 and UDB?
  188. Time is Running Out to Register for IDUG 2005 - Europe Conference
  189. how to stop db2jd?
  190. How can i write java store procedure in DB2 universal database8.2
  191. Migrating PostgreSQL to DB2
  192. how to caculate the total size of an index?
  193. how to move package
  194. Load command
  195. checking existing before drop a table
  196. Update/Load Slooooow
  197. Schema Diff Tool
  198. LOB Access Error
  199. General LOB Performance Question
  200. Federated databases on different instances on the same machine
  201. DB2 Installation Error
  202. DB2 Installation Error
  203. I/O error "243" when backup to tape
  204. All linked DB2 tables viewable on 390, but only some are viewable after migration to AIX and v8
  205. LOAD doesn't seem to work using JDBC
  206. UDF in GENERATED ALWAYS column
  207. TYPES, HEIRARCHIES etc
  208. Integrity pending
  209. SQL0901N - Any comments?
  210. Table Comparison Tools?
  211. recreate a same database
  212. Trigger Db2 V8.xx
  213. Probably dumb question
  214. UDB v8.1 fp 6 Summary table with an index
  215. Simple question on case statements and aggregating data
  216. sequence
  217. db2diag.log -> "MESSAGE : Invalid private sort memory request"
  218. What is Max Length for Index Column
  219. DB2 7.x and Linux 2.6 kernel + RHEL 4
  220. Use fedb to access remote orcale database through a db2 fedb
  221. DB2 8.2 UDF_MEM_SZ / ASL_HEAP_SZ
  222. about cursor load
  223. DB2MSCS problem
  224. Stored Procedure SQL0443N
  225. v8 cursor positioned update causes SQL4903N error
  226. How to increase page size 4k to 16k
  227. Reorg Table daily?
  228. Viewing last execution Date of Performance utilities (e.g. Runstats, Reorg)
  229. Drop column from table
  230. IDUG 2005 Europe Conference: Call for moderators
  231. Cannot find db2idrop
  232. GENERATED ALWAYS AS IDENTITY clause
  233. SQL30081N A communication error has been detected
  234. Creation of Indexes in UDB for LUW
  235. IBM Single System View Monitor for DB2
  236. DDL for Creating the Auxilliary table associated with a CLOB column
  237. Slow connects to database
  238. Need DB2 Tuning/Optimization Specialist in D/FW for 6-8 weeks
  239. Need DB2 Tuning/Optimization Specialist in D/FW for 6-8 weeks
  240. load in an atomic statement -anyone resolved this??
  241. 8.1 and 8.2 "compiling"
  242. rows read vs. rows selected.
  243. iwh2serv.exe error
  244. Exporting just schema/metadata (w/o data) in DB2
  245. Db2 version 8.1 & FP5 installation Steps
  246. DB2 DAS causes transaction log to fill up
  247. trigger fire at not null columns
  248. as400 driver
  249. as400 driver
  250. filesystem layout for installing db2
  251. .Net and DB2 triggers
  252. Log Shipping from Primary Server to Backup and vise versa.
  253. Do I observe the DB2GENERAL calling convention in my Java UDF?
  254. Register by this Friday, 30 September and save 226 Euro on full conference registration!
  255. querying the number of connected components
  256. DB2 Federated connection problems
  257. Cannot allocate additional FCM - v8.2 DPF
  258. DB2 concurrent connection
  259. max number of colums - DB2 version 8.1
  260. About logfiles in db2
  261. Java Store Procedures Help
  262. Question on event monitors
  263. Notification email address gets truncated
  264. DB2 Locking: Subquery to a Long Federated Query
  265. HADR and Type 4 Driver
  266. Instance on Multihomed Host
  267. db2 Script and Outputlinesize
  268. PK--> FK relationship between tables of different databases
  269. Small & Large Lobs
  270. YYYYMM "between" selection on date column?
  271. Hardware & stuff
  272. get request dynamicaly
  273. Order BY with FETCH 1 Rows Only DB2 v7.1 not allowed
  274. Development Center, 8.1 or 8.2, UDB
  275. how to monitor restore process during rollforward ?
  276. How to start Control Center in different language?
  277. Problem with Time Stamp as a Composite PK
  278. Problem in Insertion
  279. DB2 Architect
  280. Custom Trigger Event
  281. help request
  282. Exporting Client Configuration Assistant definitions from one computer to another
  283. DB2MQLsn - Where?
  284. How to lode/import all files in same time
  285. java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
  286. start instance node problem
  287. PREPARE stmt FROM stmtText and table names
  288. database name
  289. Formatter for SYSTABLES PACKED_DESC ?
  290. DB2 Error
  291. WANT limit the database accessible to some machine
  292. using dynamic sql to write a procedure for table creation
  293. Unable to update DB2 V7.2 FP5 to FP14 on AIX 4.3.3
  294. Host Variable, SELECT INTO
  295. COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIX
  296. Net Search Extender
  297. Multiple connections to the same database in Cobol
  298. TCP/IP Comm Error
  299. Getting just the first couple records
  300. Primary-Contingency Setup
  301. need sql queries for following
  302. Bug?
  303. DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704
  304. db2 udb 8.2 ignores indexes
  305. SET CURRENT LOCK TIMEOUT
  306. upgrade to bd2 udb 8.2 slowed down queries.
  307. Default date format for a DB2 instance
  308. Scheduling Database - Design Help!
  309. Mysterious Trigger error DB2 UDB v8.1.5
  310. Source code resource
  311. DB2 UDB 8.2 for Linux and the ODBC-driver ?
  312. Wrapper development question
  313. error message DB2 UDB 8.1.5 LINUX
  314. month between 2 dates
  315. Best practice
  316. Upgrade
  317. describe table ignores alias ?
  318. DB2SET issues
  319. Getting next val in a sequence when the table is empty
  320. SQL to Generate Record Combinations from input string
  321. check_backup script required
  322. db2icrt on Debian Sarge fails
  323. DAS/email notifications
  324. JAVA UDF Accessing Another static class
  325. Tuning for rollbacks?
  326. Omnifind and DB2
  327. sqledosd(), sqledgne() - list db directory
  328. Db2jdbcBind
  329. Can not run DB2LOAD in parallel
  330. IBM.Data.DB2.dll on .Net 2.0 framework
  331. REOPT ALWAYS for v 8.2 SQL procedures: does it work?
  332. Problem in DB2 provider for .NET Fixpack 10
  333. function sequence error on aix5.2
  334. Put database in single user mode
  335. URGENT-NEED HELP ON FILE MANIPULATION
  336. URGENT-NEED HELP ON FILE MANIPULATION
  337. Ports for DB2 behind firewall / ssh port forward
  338. Escaping in db2 load
  339. Problem batching stored procedure calls using JDBC
  340. Exclamation point in password irritates DB2 CC?
  341. SQL6031N after /etc/services was changed.
  342. HELP : ANY LOAD EXPERT OUT THERE
  343. SLOB in Table
  344. Converting a correlated subquery to a non-correlated one
  345. Nested Stored Procedure returning result sets in DB2 on AS/400
  346. Question on space for a reorg
  347. IDUG 2005 Europe Conference (Early Registration Deadline Approaching)
  348. DB2 7.1-7.2 where can I download trial ?
  349. db2diaglog errors
  350. visual explain
  351. How do I code this complex select statement
  352. Problem with prepared statements of DB2 using OLEDB
  353. JDBC - getColumnName for stored procedure not returning the column name
  354. Package codepage different from database codepage
  355. how to force a disconnect pending application which seems hang?
  356. DB2 error on AIX
  357. SQL0501N error in simple procedure
  358. Unique Vs. Non-Unique Indexes
  359. test
  360. 2 Phase Commit for JDBC Universal Driver Type 4 connectivity
  361. How to get Db2 admin Level DB2 v8.1.5.449
  362. Some questions on Declared Global Temp. Tables
  363. Bind abends with 0C4 when DEGREE(ANY) option is used
  364. Health Center Email Notifications Stopped
  365. DB2 UDB and Cobol on ZOS
  366. Modify db cfg
  367. Stoping a runnaway task in the Task Center
  368. Downloading 64-bit UDB PE
  369. DBConnect
  370. Scheduler stops for no reason
  371. Strange behaviour when using LIKE with %
  372. Federated problems 1100N
  373. time measurement with snapshots
  374. SQL on DB2 - restrict number of rows returned
  375. Urgent - OS scripts fails in Task Center with fixpack 10
  376. DB2 UDB 8.2 for Linux and the ODBC-driver
  377. Change format US-1252 to UTF-8
  378. Can I put DB2 into maintenance mode for --
  379. Warning Message: High-water mark has moved for pool
  380. Wrong edition installed - reinstall needed?
  381. DB2 authentication using padl
  382. poor query performance
  383. SQL 1224 error
  384. SNAPSHOT_FILEW stored procedure
  385. DB2 Connect db2cli.ini file changes
  386. Fetch rows faster with JDBC v2.
  387. What is this process - db2dascln
  388. DataPropagator for z/OS New Version?
  389. database offline
  390. configuration parameters
  391. not in subselect
  392. lock wait for Capture service in replication
  393. which udb 8.2.2 processes really need to run as root?
  394. Replication differential
  395. Replication question
  396. Does Visual Explain work on a GLOBAL TEMPORARY TABLE?
  397. After reboot primary and standby starts up and then they turn into catch up pending
  398. How upgrade WSE to ESE without uninstall/install?(+)
  399. help me out
  400. Db2 procedure error
  401. strange problem
  402. db2cc hangs on win2k with "C0000005 Access Violation&qu
  403. Is this query possible ?
  404. error of dynamic SQL
  405. Tivoli System Automation for HADR
  406. DB2 UDB LUW: query, cursor types and optimization
  407. SNAP_GET_DYN_SQL
  408. function usage in dynamic SQL
  409. TCPIP port number
  410. Configuration Assistant problem
  411. News group problem?
  412. To change password for DB2 user
  413. question about dynamic SQL
  414. SNAPSHOT_BP function problem
  415. Photo Ipods
  416. Error while exporting clob
  417. DB2 MIGRATION: SYBASE Functions list
  418. DB2 Net Search Extender help!
  419. Strangeness with CASE stmts and ATOMIC keyword
  420. DB2 Net search extender problem!
  421. Alter table ADD COLUMN using UDF problem
  422. Connect Using db2cc and db2ce
  423. FP10 fun
  424. How to convert a string to integer?
  425. Attach Databasefiles
  426. HOME TEXTILE BOUTIQUE SERIES TOWEL BATHROBE AND GARMENT
  427. ORDER BY and case DB2 8.1.5 LINUX
  428. agents -recommendation
  429. How to Update multiple tables in a single SQL update Statement?
  430. Alternate fixpacks and DB2 Connect
  431. Are LOB's replciated using HADR ?
  432. unload data on DB2 Z/OS to DB2 UDB on Windows
  433. SQL PL question: Get Diagnostics
  434. Attach Database
  435. bufferpool heap taking 4 GB when it is only specified as 750 MB total
  436. hmz... what's going on???
  437. FP10 - ooops!
  438. active users
  439. FP10 Now available
  440. where to find pricing?
  441. Error while compiling view
  442. SQL0351 when acccessing V7 from V8 client
  443. Extensions of DB2 engine
  444. Win2k Memory Allocation - BP v Sortheap
  445. PRUNE HISTORY question
  446. share tablespace
  447. Faster Runstats?
  448. UDB 8.2.2 specify statement-delimiter inside script?
  449. failover with HADR
  450. Run db2updv8 after installing fixpack 9a?
  451. Backup fails with SQL2059
  452. db2cc/db2ce on Linux
  453. Problem with a UDF
  454. CLI trace and DBD::DB2
  455. Bufferpools
  456. Delay a trigger
  457. How to replace Procedures/Functions?
  458. PROCEDURE with one-character name, not returning RESULT SET
  459. Convert Current Time to Dec
  460. Strange message in db2diag.log
  461. L2/3 Cache
  462. No select privilege on sysibm.sysdummy1
  463. SQL0374N on METHOD for structured-type (V8.1. fixpak 8)
  464. Hmz.. what's this then.
  465. db2start fails on Solaris 8.2 (SQL1042C)
  466. UDB V8 FP8 - Tablespace Filesystem caching enabled for DMS Raw?
  467. DB2 UDB ULW: Replacing an SQL procedure language based function used in object definitions?
  468. No start database manager command was issued. SQLSTATE=57019
  469. Questions re WITH RETURN TO CLIENT
  470. FYI: developerWorks/DB2: Tracing Procedures
  471. DB2 V8.2 install on Redhat 3.0 - AMD 64 bit
  472. Health Monitor Crash
  473. Change column name in replication environment
  474. Information Integrator with Oracle
  475. How to avoid Tran Fail Log error with update statements
  476. Applications hang in a "Commit Active" state
  477. db2 transactions per second
  478. db2plug and Control Centre
  479. Triggers-Replication-unique key
  480. Db2 Net Search Extender help!
  481. Zugriff auf DB2
  482. DB2 Program to connect to 2 databases
  483. What is JDK_PATH used for?
  484. db2dasdiag.log is filling up the filesystem
  485. Before insert Trigger
  486. db2 Redhat 3.0 AMD 64 bit - db2cc problems
  487. db2 v8.2 reorg
  488. javaw.exe
  489. Any Replication Gurus?
  490. Do I miss anything?
  491. Current library on AS/400
  492. Encrypting Data in DB2 Connect
  493. DB2 Connect - PE v8.1 - problem
  494. Use Of NULL Keyword In DB2
  495. How to send Mails out of a DB2 database on SuSE
  496. locks_held_top - Maximum Number of Locks Held monitor element
  497. i want to rename the table schema
  498. Java Type 4 Coonection in V8.x
  499. "Devices"
  500. fetch first in full select
  501. how to select source of procedures and functions
  502. Trigger and Call results in the 57053 problem but why?
  503. BIZZARE MQT-BASE Table Locking Behaviour
  504. Managing users under DB2
  505. increase write speed to UDB
  506. Will splitting up a table improve our select performance?
  507. Focused DB2 Education at IDUG 2005 - Europe
  508. Focused DB2 Education at IDUG 2005 - Europe
  509. sqluexpr - external routine problem
  510. Solaris client suddenly hangs
  511. A snapshot of the database market and DB2 by Philip Howard
  512. DB2 Hosting
  513. Licensing
  514. Multi RDBMS Support
  515. IDENTITY_VAL_LOCAL AND STORED PROCEDURES DB2 ver 7.2
  516. Advantages of "MERGE INTO"
  517. memory usage
  518. AS/400: generate unique numbers
  519. Dumb IBM Marketing?
  520. db2 8.2.2 error when creating database
  521. EXPORT DATA without quotes"
  522. Examples wanted
  523. passing parms to query in DB2 Unload
  524. DB2 Audit Trigger Generator [long]
  525. Upcoming DB2/XML webcast: Aug 16
  526. Making stored procedures resident in memory
  527. one performance question...
  528. one performance question...
  529. Long Varchar - when will it no longer be supported?
  530. migration toolkit (from oracle 9.x to udb 8.2.2)
  531. V8 FP 8 : Restore error messages.
  532. db2 8.2 fixpaks
  533. Db2 full text search help!
  534. reading DB2 with isolation CS - why is the lock blocking?
  535. Moving to AS/400
  536. Extentsize/Containers/Tablespace
  537. data access across instances
  538. DB2 SQLJ.Install_jar(file:///user/shared/java/javamail.jar', 'MAIL') Error 58004
  539. equivalent of oracle's dbms_output.put_line in db2
  540. Odd Security Need
  541. Euro Symbol and ASCII-Tablespace
  542. How switch db into read-only mode?
  543. DB2 version 7 JDBC drivers
  544. CAN WE MAKE USE OF CURSORS IN A SIMPLE BLOCK IN DB2?
  545. pass an recordset to a procedure
  546. New features for the next version of IDS
  547. Bug in DB2 8.2
  548. Finding DB2 instances and databases
  549. Year, Month, Day functions
  550. db2_all