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. can't create database cause access failure in db2spcat
  2. MS-DTC and .Net client doesn't work with Transaction Required
  3. Unable to select from temporary tables
  4. DB2 SQL Formatting
  5. Problem with Rebuild Index after loading data with DSN1COPY
  6. Handling Special character in openquery
  7. Problems with national characters
  8. SQL PL online manual/guide?
  9. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  10. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  11. DB2 UDB Security
  12. access pseries DB2 from iseries using COBOL and RPG
  13. Apply Program Not Moving Data
  14. db2_awe and more than 4GB memory on Windows
  15. NAS for DB2 active logs
  16. MDC Rollout
  17. Shameless self-promotion
  18. Oracle DBA Inherited DB2 System
  19. Trigger Failure Cancels calling transaction
  20. Performance of union all views
  21. Why does the execution plan hav a nested loop join when an UDF is used?
  22. SQL Procedure Question
  23. Embedded Database Research
  24. Where are the downloadable versions of the V8 manuals?
  25. Sybase to UDB Migration - Code Freeze
  26. Update Fails with SQL0407N
  27. sql replication script
  28. problem while index creation
  29. DB2 replication - Apply program not replicating
  30. Error in nested SQL Procedure
  31. SQL Statement length exceeded
  32. compact and compress?
  34. materialze query?
  35. Putting Information Center on hard drive
  36. 64-bit platform support for XML Extender
  37. Can I store binaries outside /sqllib/function?
  38. clob question.
  39. Get the DB2 version number through SQL (onMVS)
  40. How I can get statistics by indexes using?
  41. Packagename of a routine
  42. Change Server Name on a DB2 Server
  43. drop table/recover space
  44. Can I replicate data between a pair of databases in the same instance?
  45. Stored Procedures (db2dari.exe) sucking up memory
  46. Does DB2 WSUE supports 64 bit computing ?
  47. DIA3819C A file sharing violation has occurred, filename was ""
  48. UDB V8 FP9a "log data" monitor elements
  49. Cannot connect to db2 using jdbc
  50. Statement sequence in SQL Stored Procedure
  51. retrieving clobs over wan
  52. UDB V8 (Fixpak8) - "Database files closed" monitor element
  53. Why are the "same" queries optimised differently ?
  54. DBA2052E
  55. Db2 help needed
  56. DB2 V8 - user account TROUBLE
  57. DB2 port
  58. using jdbc to connect to db2
  59. Difference between a 'file' and a 'table'
  60. load utility does not work from control center
  61. Char in US Code page vs Char in UTF-8
  62. problem with unloading data from DB2 ver7
  63. problem with unloading data from DB2 ver7
  64. DB2 and PHP
  65. No future for DB2
  66. Vargraphic not available in GUI
  67. Prevent Infinite Looping in Q Replication
  68. Help! Call sql procedure - SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS
  69. show comments for columns ...
  70. solution on source code page "1114" to the target code page "UNKNOWN".
  71. Merge stmt
  72. Design Advisor does not recommend indexes !!
  74. Reorg of very large tables
  75. UDB V8.2 (FP1) - DGTT WITH REPLACE vs. delete * from DGTT
  76. HADR / Q replication comparison
  77. Trying to get scrollable result set from SQL stored procedure
  78. commands to copy archived logs in disk to tsm
  79. DB2/390 v8 - union all subquery in select list returns wrong results
  80. Inner Joins and UDFs
  81. how to archive logs to disk and then use tsm to back them up to tape
  82. Table function GET_DBM_CONFIG missing in Fixpak 9
  83. How to Stop a Database
  84. DB2 AS400 convert character to date format
  85. DB2 AS400 convert character to date format
  86. unable to install SQL Express 2005 CTP
  87. overflows : interpretation
  88. DB2 Event Monitor puts "?" for all the values
  89. Help to compile C UDFs using gcc on AIX (bldrtn)
  90. Table size estimation
  91. Copying my DB2 database connections
  92. Need FixPack 7a urgently. Plz. Help!
  93. DB2 v8 --- Creating the DB2CERT database...
  94. DB2 v8
  95. DB2 replication setup step by step
  96. Help with "SQL30081N A communication error has been detected"
  97. DB2 and cygwin ...
  98. resetting monitoring switches
  99. Cursors defined as "WITH HOLD" are closed after commit.
  100. MQT/Staging Table/Syntax
  101. Division by Zero or changed order of applying predicates in SQL
  102. q replication/sql replication
  103. Pick until enough
  104. very strange ... SQL0910
  105. Modification time
  106. SQLSTATE 42997
  107. DB2 Replication - synchtime
  108. How do I increase the size of the output message parameter of a debugger
  109. SQL0270 RC 73
  110. HADR Questions
  111. DB2 solaris installation without open windows?
  112. DB2 Warehouse Site Agent!!
  113. privileges on packages - db2 8.2.2
  114. Journal - Task History - Database backup success is expired
  115. [Restore DB] backup from linux & resotore to windows
  116. Can we create an alias for a sequence in db2
  117. error : DIA3207E L'appel TCP/IP "gethostbyname"
  118. Will the new RECOVER Command run in parallel on a partitioned database ?
  119. DB2 migration v5 to v8.1
  120. Change a table's tablespace
  122. db2advis - Disk Limit Constraint
  123. TPC-H Query Results - 1GB DB
  124. Problem running control center.
  125. UDB 8.2 poerformance problem
  126. How to DELETE with COMMIT COUNT
  127. DB2 Before Insert Trigger not acting like before?
  128. SQL Problem - Date / Txn Sequences
  129. Bogus data type incompatible error SQLSTATE=22001?
  130. Select column user via clp without getting token user
  131. Can CLP output be timestamped?
  132. Problems with Java SPs on Win2003 server
  133. SQL0289 when Alter table space
  134. db2spmrsy
  135. Question about VARCHAR Vs. CHAR fields
  136. DB2 8.1 32-bit Linux migration to 8.2 64-bit on AIX
  137. Delete vs. Merge
  138. DB2 Connect V8, Schema functions, and CLI driver
  139. Materialized Query Syntax--I can't get the samples to work
  140. Problems with connection pool for DB2400
  141. Question on Package Cache Overflows
  142. db2move questions
  143. db2move questions
  144. temporary tablespace without sufficient page for replication
  145. SQL UDF works very strange. Bug or feature?
  146. Same software, different hardware and abominable performance
  147. replication scheduling
  148. Migration path -> Unidata V6 to DB2 V8.2
  149. Any Info to join the "Serrano" Beta for the Next Websphere Information Integrator?
  150. Nickname in two phase commit ???
  151. Nickname in two phase commit ????
  152. -22205 return code from task center
  153. APAR IY66088
  154. Windows authentication on DB2 UDB 8
  155. Test Post - Ignoe
  156. DB2 Views
  157. Isolation question for DB2 beginer
  158. DB2/UDB B-Tree Indexing, Reverse Scans
  159. Call a View over SQL (DB2 UDB V8.1.6)
  160. using nextval in external udf
  161. UNION ALL View
  162. Stripe sets, high watermark and restores
  163. export package
  164. join 2 databases
  165. DB2 & System Dates
  166. DB2 Client on SUSE 9.3?
  167. Triggers - can I have it fire only if certain columns actually change?
  168. Raw Device Wiggle Room?
  169. read only standby db
  170. SQL Abfrage auf DB2 UDB V 8.1.6
  171. Problem with UDF
  172. Migrating Application SErver with DB server
  173. DB2 HADR 8.2.2 for REORG maintenance
  174. Database lost - Help me
  175. Database lost - Help me
  176. locate and select
  177. Database lost - Help me
  178. Confused over data page utilization
  179. Unexpectend end of ZLIB input stream ???
  180. split mirror : high availability
  181. db2move problem
  182. Problem with sqlp_AsyncLogReadAPI, generating error every 2 second
  183. Scope problem? UDB DB2 R8.1.5 Linux
  184. result set is closed
  185. Handling Money Via UDT / UDF (i.e. homegrown "extender")
  186. Oracle Transparent Gateway
  187. How large of a bufferpool can you create?
  188. Message being sent to port 523 (DAS)
  189. PRUNE Logfile Command Question
  190. Days/date redux UDB DB2 8.1.5 Linux
  191. HADR works with Peoplesoft (JDEdwards)
  192. Password Settings
  193. some problems with the replication
  194. Cleaning up after a crash
  195. Problem Upgrading to FP9a Using Alternate Fixpack
  196. update db cfg dbheap
  197. SQL0567N
  198. Fixpack 9a now available
  199. Index / Primary Key
  200. Transaction Log Full and Stored Procedure
  201. Redirected restore problem
  202. DB2 Connect Problem
  203. backup
  204. JCL or CICS from store procedure
  205. Search multiple job sites for you!
  206. Problem with SQLFreeStmt
  207. backup image compatibility between different versions
  208. windows executable error - db2
  209. Db2 select statment
  210. Different NUMBLOCKPAGES across Partitions (DPF)?
  211. problem with db2 authentification
  212. Passing And ARRAY to a Stored Procedure
  213. Problems with Type 4 jdbc driver
  214. Consultant Needed
  215. Best Practices for Copying of Data Between Instances
  216. file versus command line issue
  217. How to extract a list of top running queries on a database on a single day
  218. Poor insert performance
  219. Tempspace only one container is being used - EEE!
  220. how to update sqlj routine source in catalogs ?
  221. Invalid arg exception when connecting to db w/underscore in name
  222. convert duration in seconds to hh:mm:ss
  223. Activate db - command changed in 8.x?
  224. abysmal performance with scalar query
  225. Program querying DAS for isntances/databases
  226. How to pad a sequence value with zeros
  227. Emergency question about SQL0818 gotten on SQLJ proc
  228. converting existing DB2 v8.1.1.72 AIX 5.2 to 64-bit. Need info please.
  229. Database size
  230. Prove HADR
  231. db2 store procedure-- sqlstate=38503
  232. jdbc connection crashing database
  233. Union Problem
  234. Moving database to a larger hard disk partition
  235. DB2 Managed Service Provider
  236. script to restore db from comand line
  237. Change passwd programatically?
  238. Last commited transaction less then backup image timestamp after restore with rollforward?
  239. Moving home directory on DB2 instance?
  240. HIS 2000 connectivity problem
  241. replication
  242. db2 AIV extenders for Linux
  243. problem with a binary (maybe)
  244. installing db2 8.2.2 on RHEL4
  245. How to use cygwin xterm and db2
  246. SQLSTATE: 23505 UDB DB2 8.1.5
  247. Backup Options
  248. DB2 in production environment.
  249. Schema Mapping
  250. Connection to iSeries with Windows credentials requires Local Admin rights
  251. Tools to convert Mysql DDL to DB2
  252. AppDetective and DB2 instances
  253. Federated Insert and local update in on transaction not possible
  254. decimal to char problems
  255. Libeay32.dll conflict
  256. Make DB2 administrative APIs available through SQL
  257. DB2 Everyplace problems
  258. File System Full
  259. RTRIM is not truncating trailing spaces at the end of the line
  260. files under db2dump
  261. Replication Center SQL Replication Subscription sets
  262. User password?
  263. Seek DB2 translation of complicated Oracle join statment
  264. DGTT Changes access plan (extra SORT + RIDSCAN)
  265. Accessing old IBM DB2 V5.2
  266. restore db2 backup with include logs
  267. ODBC Driver
  268. Decomposing XML
  270. DB2 Archive Failure
  271. Workload/Query Generator
  272. Execute multiple statements in a Procedure
  273. Backup Question
  274. db2advis - works with indexes but not MV
  275. Status codes from Various UDB Utilities
  276. Automatic table maintenance
  277. Pivot or Invert row data
  278. Restore catch 22 db2 udb 8.1.5
  279. DB2/UDB and Read Locks
  280. DBexpress with DB2 questions
  281. Max number of Cursors?
  282. SQL30020N Execution failed because of a Distributed Protocol Error
  283. Cannot create sample database
  284. Date format db2 udb
  285. Where do I find out more?
  286. What is the difference between workgroup server and enterprise server edition?
  287. DSNTIJMS job in DB2 for z/OS
  288. Get human-readable error meesages ala db2 ? sql00911
  289. Number to Time Conversion
  290. No error messages from bind
  291. SMTP refuse email <instance>@<host>
  292. Structured type
  293. CONNECT TO hangs, no response
  294. How to detect running under RRSAF or CAF?
  295. Size of "Indexes and Materialized Views"
  296. Seek DB2 translation of Oracle statement with date stuff
  297. performance & behaviour question
  298. Lost active log, can't connect to database..
  299. db2v81 PE inst on gentoo(linux),amd64
  300. HADR primary connection failure tryin to communite to standby
  301. Empty Query Cache
  302. Warehouse Manager Agent problem
  303. * Need help on Backup *
  304. use dynamic SQL in external user-defined table function
  305. Monitoring And Maintenance
  306. Position open to fill - embarking on Data Warehouse project
  307. problem with a restore maybe ...
  309. Corrupted download files for DB2 8.2 PE Linux 2.6
  310. MQSEND on z/OS and DB2
  311. Other memory
  312. Help Product Information - Information Integrator for SyBase to UDB Migration
  313. SQL - Unexpected Token "date/interval"
  314. OFF TOPIC: x86 Server Selection
  315. db2diag.log error
  316. generate row number in result set?
  317. Dates not in the future
  318. Query Execution Time
  319. >255 chars into stored procedure via ado
  320. Latest stable version?
  321. Transferrate / overhead
  322. -101 on alter table statement
  323. Restoring from a crashed system.
  324. URGENT:Exporting and Importing data using IXF format
  325. question about online backups
  326. Problem with updates via MS Access
  327. logfile on db2
  328. Can I customize DB2 catalog with my own tables?
  329. SQL0206N "C" is not valid in the context where it is used. SQLSTATE=42703
  330. Information Integrator - AIX ODBC - any user experiences?
  331. Question on dropping a trigger
  332. Library issue
  333. No Subject
  334. problem with different access plan (slow & fast) for the same SQL-Statement
  335. Code in the database or middle tier (the CLR controversy)
  336. db2pgixt
  337. log_retain_status and logarchmeth1
  338. Problem with federated database
  339. I am a new user help needed
  340. Problem with a query with MAX function
  341. why I can't display a jpg Blob field in web?
  342. SAR file -- can this be imported and edited?
  343. SQL-to-XML error when calling dxxgenx
  344. way to speed-up/tune database creation?
  345. Database market share 2004
  346. db2 backup issue on windows
  347. SQL10007N Message "-1390" could not be retrieved. Reason code: "6".
  348. haven't got a clue on this error.
  349. Unable to restart DB2 Instance
  351. Run-Time Clients
  352. customize CREATE DATABASE
  353. URGENT:Anybody out there with DB2 6.1 SDK for windows
  354. URGENT:Anybody out there with DB2 6.1 SDK for windows??
  355. SQL0270N How to create Java UDF with SQL?
  356. ERROR when using get db cfg command
  357. SQL0950N error
  358. SQL0518N
  359. Unlocking DB2 table/row locks
  360. reorgchk reorg interpretation
  361. SQL0973N QUERY_HEAP_SZ to small
  362. Date format question
  363. Query syntax
  364. Query question
  365. Importing from DEL file where a column value begins with a " ?
  366. Could not build query
  367. Hardware Planing..
  368. How to make a Query with diffrent variables, beeing empty or not?
  369. DB2 8.2 JDBC Application --> CHARACTER and CHAR
  370. increase cpu usage for a db2 process
  371. Importing V8.2 IXF files into V5.2
  372. where to find V7 release ?
  373. Automatic Storage
  374. unable to connect to a db2 server through the control center ... - Help !
  375. db2/UDB replication problems (maybe ...?) - Help needed
  376. Test
  377. Extender server problems
  378. Replication Cold Start
  379. Production Support Analyst Needed
  380. Matching IP Address to subnets.
  381. Net View Ext & BLOBs
  382. Connections
  383. NetApp Filer
  384. Vennela Technologies Offering Beautiful Courses On Oracle
  385. Insert CLOB / BLOB
  386. Loading datetime values from SYBASE into DATE type in DB2
  387. DB2 restores with Veritas NetBackup?
  388. Where can I find what type of field DB2 has
  389. JDBC issues with setBinaryStream an AbstractMethodError and a cast
  390. Calling a DB/2 v8.2 stored procedure from perl
  391. Supra to DB2 migration
  392. cannot connect from Crystal Reports to remote DB2
  393. 8.2.2. Windows "net stop db2-0" with activated databases does not work
  394. looking for not JAVA admin tools for UDB V8
  395. DB2 Stored Procedures called from REXX
  396. Login to AS400 from SQL Data Transformation Services
  397. 8.2 Windows: Health Monitor not always work
  398. CLI0112E Error in assignment
  399. Coding Standard for developing Stored Procedures
  400. SQL0444N Routine "DB2XML.CONTENT"
  401. need header values
  402. Db2 v 8 is buggy
  403. Code page problem: workaround
  404. Where to find FP9 for Linux with kernel 2.6?
  405. Optimization level in db2?
  406. Error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 while using ADO
  407. copy database structure
  408. compact lob data?
  409. Problem connecting from AIX to Windows.
  410. PDE 8.2.2 untar problems
  411. federated databases on 2 instances
  412. Transaction log full
  413. Comparison of Performance of SQL and external Procedures
  414. Doc Fixpack 9 for V8 ?
  415. URGENT! trouble with char conversion from nickname
  416. iSeries DB 2 to UDB2 V8.1
  417. a query at db2
  418. unload data
  419. String data right truncation. SQLSTATE=22001
  420. unable to load DLL 'db2app.dll'
  421. Allocation error when allocating memry to CLOB host variables
  423. relation_data_serv problem
  424. sqldEscalateLocks and performances
  425. Stored Procedure - Handling all error code with a single condition !!
  426. Problems with code page
  427. the USER
  428. I think to have a problema with DB2_SQLROUTINE_COMPILE_COMMAND
  429. Install DB2 in an FSIOP/IxS Card in an iSeries
  430. JAVA udf 8.2.2
  431. SQL Stored Proc - Security issue
  432. creating dsn for mainframe db2
  433. New Registry Variables in 8.2.2 (FP9)
  434. HELP ME problem with *.sqc
  435. Handling Time Stamps
  436. No system temporary table space and a SQL query
  437. Deadlock or Timeout when delete/update rows with BLOB
  438. Restoring Journals on an iSeries Box
  439. method to write to a flat file from Stored procedure
  440. HELP! Variable looses value in loop within trigger
  441. get snapshot for dynamic sql
  442. Strange or normal IDENTITY behavior?
  443. DB2 V8.2.2 Manuals (FP9)
  444. Seek equivalent of Oracle's empty_clob() for CLOB creation
  445. Equivalent of Oracle's DBMS_LOB.GETLENGTH(COLUMN_NAME)
  446. Enabling database for DB2IMAGE
  447. Strange inconsistences when repeating a query more than twice in a row
  448. Strange inconsistences when repeating a query more than twice in a row
  449. Is there a "go to" statement in DB2 Stored Procs.
  450. viewing privileges for stored procedures
  451. Aggregating text
  452. Trigger syntax ? problem
  453. multilanguage problem
  454. connecting to remote 7.1 db2 database
  455. Equivalent of Oracle's to_date('03/04/2005','MM/DD/YYYY')
  456. Comparing dates using date function and arithmetic
  457. db2LogRead API Error
  458. how to print a new line character
  459. Control Center lock
  460. accent insensitive diacritic insensitive data retrieval
  461. custom collating sequence
  462. generated column
  463. Stored procedures in SYSPROC schema
  464. primary =/=> unique?
  465. FP9 / can't find Apar GG04517
  466. FP9 installer breaks Information Center (Windows)
  467. Using LOWER function in DB2
  468. db2app.dll
  469. Creating Dataset from DataAdapter VS.Studio.NET & Db2
  470. db2 concurrency control question
  471. DB2 equivalent of Oracle to_char(created_date,'MM/DD/YYYY')
  472. How to define this kinds of constraint.
  473. Accessing Oracle from DB2 Stored Procedure
  474. Shameles self-promotion
  475. problems with UNION
  476. changing password
  477. unloading data from db2 v6 tables to os390
  478. Queston on DB2 lock
  479. SQL Stored Procedures X Java Stored Procedures in DB2 8.2
  480. Problem with sequence in UDB 8.2
  481. data warehouse
  482. DIA0001E An internal error occurred. Report the following error code : "ZRC=0x8136001C".
  483. SELECTing from multiple databases?
  484. Performance: CAF vs RRSAF
  485. Password invalid, when logging on as db2inst1 with a password
  486. SYSPROC.ENV_GET_INST_INFO() not working...
  487. Need good idea
  488. DB2 UDB v8.2 Fixpack 9 Problem starting Information Center
  489. tablespace move from 32K to 4K page size on same instance
  490. DB2 version info
  491. Error Installing ESE Fixpack 9 for Windows - Help Please
  492. error sqlriResolveOpFunc
  493. Quck question on port numbers for V8.X and HP
  494. Stored Procedures: RESULT SET.
  495. Stored procedures debugging.
  496. DB2 Fixpak 9 now available for LUW
  497. [Fwd: Double lock on iseries db2 transaction]
  498. Sr. Database Engineer Needed - Preferably DB2 (Silicon Valley)
  499. Help creating trigger
  500. db2 connect statement with current schema
  501. DB21015E - New Error with Fixpack 8?
  502. how to copy a clob column data......
  503. selecting data based on rowid
  504. federated database
  505. Simple question
  506. how to pass value to a stored procedure at runtime....
  507. SQL
  508. Clone a partial DB on Linux running in circular mode
  509. SET INTEGRITY question
  510. Help with an SQL Query
  511. Calling sqleintr or exit causes program (linux) to hang (due to deadlock by pthread)
  512. Cannot grant sysproc function to user
  513. DB2 Data directly into Microsoft Excel
  514. DB2 crash?!?
  515. UDB v 8.1 - SQL0925N SQL COMMIT invalid for application execution
  516. UDB v 8.1 on win2000 - SQL0925N SQL COMMIT invalid for application execution
  517. Connect to remote server using db2 and Perl
  518. Translate this Oracle Trigger ...
  519. Help with Oracle to DB2 trigger translation
  520. Row Locking issue
  521. event monitor -dropped default one
  522. Db2 server problem, Urgent please need suggestions
  523. Data Compression
  524. SEARCH / KNOWN discovery question
  525. Same statement, different application, different runtime
  526. If statement
  527. Passing a resultset from a nested Stored Procedure
  528. Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L
  529. problem running db2cc, DB2 v.8.2 on AIX
  530. Generating rows on the fly
  531. Please Help - DB2 Specialist Consultant Required
  532. sql1042C / sql1036C on create database?
  533. client v7 to connect v8.1 mts error
  534. DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)
  535. Load commit
  537. Problem when archiving log files
  538. DB2Advisor error
  539. How to configure windows with ibm db2 odbc driver?
  540. Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
  541. DB2 SNMP Monitoring - Missing the Boat - Big Time
  542. JDBC Driver Defaults
  543. Client Access ODBC DB2 driver problem
  544. LDAP authentication for DB2
  545. Placing a Lock at record level in a table.
  546. Browsing through a table
  547. Federated database problem
  548. Calling stored procedure in a trigger
  549. How to view the status of DB2 Load utility on Windows/Unix
  550. what is the difference between cloudscape and derby?