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