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